Summing over multiple pivots

GenDemo
Participant V

HI

I have a table with multiple pivots (as in the screen shot below), and I need to calculate a ratio of sums of different columns - I dont know how to have the pivot_where() functions to achieve this.

d7d1aa60-e54f-4bf8-bd30-7c5955513bbc.png

In layman's terms I need the numerator to be the sum of all the product types where is Approved = yes.
The denominator to be the sum of all the column, except where say product ‘Flex’ is ‘no’.

Then the ratio between these 2 values.

Hope that makes sense...its for a rather convoluted business rule for a KPI.

0 0 425
0 REPLIES 0
Top Labels in this Space
Top Solution Authors