Summarize percentage in CrossTab

[dbe]

Hi,

I have a Crosstab with 3 columns, which are shown on a monthly bases.
Column A and B hold a number, Column C holds a calculated percentage on a row bases.
I would like to add a grand total to the crosstab report.
For the number columns, there is no problem.
But, the percentage column is also summarized, and I get a percentage like e.g. 4000 %, which is incorrect.

When I look at the expression, it says "Total ( currentMeasure within detail ... ) "
Is there any way I can get this to work correctly?

Thanks in advance.

Kindly Yours
Dimitri Backaert

[MFGF]

Hi,

From the looks of the expression you are quoting, you are using a dimensionally modelled package.  It looks as though the timing of the calculations for percentage and total is the wrong way around (ie it is calculating the percentage values before doing the total).  You can change the timing quite easily - just select the percentage calculation, and scroll almost to the end of the list of properties until you see the 'Solve order' property - add a value of 2 in here.

Regards,

MF.

[dbe]

Hi,

From the looks of the expression you are quoting, you are using a dimensionally modelled package.  It looks as though the timing of the calculations for percentage and total is the wrong way around (ie it is calculating the percentage values before doing the total).  You can change the timing quite easily - just select the percentage calculation, and scroll almost to the end of the list of properties until you see the 'Solve order' property - add a value of 2 in here.

Regards,

MF.

Hi MF,

Thanks for the reply.
Unfortunately, this doesn't work.
I've tried changing the solve order, but no result...
Any other ideas?

Thanks in advance

[MFGF]

Hmmm - ok.  Does it make a difference if you change the expression of the Total row to be
aggregate(currentMeasure within set <whatever you are using as your major row headings>)

MF.

[peritas-chris]

Another thing to check is that you've set the Rollup Aggregate property for that calculation to "Calculated".  The solve order is essential as MFGF has kindly pointed out.