Hi all
I have a very simple crosstab that is something like this:
Product
---------------------------
| Sales | % Sales
----------------------------
Year | |
Total
The % Sales total should be: total(sales for [Product]) / total(sales for report)
So I override the total % sales cell and put the formula above in, set solve order to 2 but for some reason the same value is repeated in every cell on the crosstab.
Anyone know why this is?
(added attached screen capture of what I mean).
Thanks!
Hi,
Insert Calculation for number of booking with % of Number of booking.then click on the column and make the solve order to '2
Year
Revenue % of total Revenue
Product Line
Total
Insert calculation with % of total number of Bookings
Expression : total([Revenue]) / total(total([Revenue]) for report)
click on product line and make total for Product line
click on % of Total number of bookings and go to properties pane and make solve order to '2'
Thanks
Pratap