Override content in crosstab total is repeating same value

[mrl72]

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!

[Pratap Reddy]

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