Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart that calculates value in percentage of subtotal.
It is possible for a user to select what dimensions are used in that chart. Besides that, it is possible to change the order of the dimensions. Now I want the percentage to be calculated only for the last (lowest) dimension in the chart.
Number of selected dimensions can differ.
Is there something to determine what the lowest level is in the chart and do something like :
sum(value)/Sum(Total <lowest dimension> value) ?
Check attached
Great !!! Thank you very much.