In this, I'm trying to calculate 80% Potential savings for each Supplier and the number of dimension values(controlled by the panel on the left, 'Levels') that make up this 80% savings. I have written a formula for this as follows:
Sum(Price_Red)/Sum( total Price_Red)
where 'Price_Red' is the savings value and $(vDim1) is the variable controlling the dimension values that are needed to be counted.
But the thing is, I want to display this count by each Supplier in the table and right now, this only happens if I select each supplier individually from the table.
I tried looking into Sunny's answer here and modified my formula but still doesnt give the required output. Please help me include the Supplier dimension in this calculation.
In order to get the correct sort order, you will need to concat them unless a particular field won't repeat for multiple supplier. For example, I found that some of the Specification 1 were repeating for multiple Supplier. But if Specification 2 is unique to a supplier, then you don't have to combine it with supplier. But doing it won't do any harm.