Hello all,
I'm doing dimensional reports for the first time, and I have a formatting requirement which I could do in a relational report but haven't a clue on planet dimensional..
So, I have a crosstab which currently looks like this:
| Month 1 | Month 2 | Month 3 |
Customer X | 100 | 200 | 100 |
Customer Y | 80 | 80 | 80 |
Customer Z | 140 | 130 | 120 |
----------------------- |
Salesman 1 Total | 320 | 410 | 300 |
Count Customers | 3 | 3 | 3 |
----------------------- |
The "Count Customers" subtotal is calculated as: count( currentMeasure within detail [Customers] ), and it's giving the right value. BUT I'd like to format it as follows:
| Month 1 | Month 2 | Month 3 |
Customer X | 100 | 200 | 100 |
Customer Y | 80 | 80 | 80 |
Customer Z | 140 | 130 | 120 |
----------------------- |
Salesman 1 Total (3 Customers) | 320 | 410 | 300 |
Count Customers | 3 | 3 | 3 |
----------------------- |
The way I'd do it in a relational report is that I'd unlock the crosstab, drag the "Count Customers" data item onto the correct row, and change it to Text Source='Data Item Value'. However in a dimensional report this just returns the data item name ("Count Customers") , not the value (3).
Does anyone have any idea how to do this kind of thing? The requirement is fairly flexible so anything similar would do the job...
Thanks for pondering!