Adding expression(dimension) over existing expression in pivot table

[d_petrov]

Hello,

I have a pivot table with 3 dimensions and one expression.

One of the dimensions is moved above the expression.
My goal is to add percentage of green to maroon items at the top of the dimensions. (check the screenshot) .
How to do this, with expression or dimension? The calculation should be (count green cells) /  (total count of maroon+ green cells). Please, help.

Best Regards,.

D. Petrov

[chrismarlow]

Hi,

Short of a bespoke extension I don't think you will get exactly what you want, but there might be some options that get something that gets the same sort of output. For simplicity on the below I am just showing count of numbers where sum=1 (so show 1 for x and 2 for y), your expressions are going to be more complicated.

First option - if you have a variable number of items in the dimension you are pivoting horizontally, or are using other pivot table functionality, you can arrange a second pivot table above, with only your horizontal dimension & using AGGR to get the calculations over the right set of values;

Second option - if the dimension you are pivoting on has a set number of items you could use a straight table and put the calculation in the expression label;

Do either of these look like they might help?

Cheers,

Chris.