Hi
I know this is one of the basic questions.But i never worked on full client before( i haVE webi EXPERIENCE). Can anybody tell me how to create crosstab reports?I just want to know how to start creating cross tab reports. This is my requirement:
Month1 month2 ......................month 12
Code Prod name
For each month, i need to show number of products sold in that particular month.
Thanks Matt and Steve. Well, understood how to create cross tab report. Now, I have to show something like this in report:
Month1........................Month2
Code Name X..............................X
2 ..............................2
|
|
once i show data for metric X under all the 12 months, i need to show the data for metric Y again for 12 months and so on. And all the new metrics X, Y, … are displayed on new pages. Is it possible to do through slice and dice panel? If not, what is the other way to achieve this? Any clues?
Mohan,
I have 6 metrics and i want them to appear below months, but for all 12 months i want to display X first. After X data is over, i want to display Y data and so on.
Brief sketch:
Create two crosstabs, one for measure x, another for measure y. Position the crosstab displaying y relative (format table, tab appearance) to the crosstab displaying measure x.
I have one more question: What is the best practice for creating such reports, i mean where i have to show data in 6 crosstabs.
Practice 1 : Get all the measures and dimensions you need to build the reports in one query all at a time and then insert crosstabs based on this data.
Practise 2 : Get only the measures and dimensions you need to build one crosstab at a time and select ‘Build new query on the universe currently in use’ to get required dimensions from time to time.
In my report, i have only 3 dimensions which are same for all the crosstabs. The only thing that changes is the measure.
Please let me know,which practise should i approach. Again, i have to sort these records according to sales values. So i need to display same records(i meandimensions) for different measures.
Thanks