Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have following table and need to do cumulation with dimension values. When my Feild'Flag' is 'No' then cumulation should not happen. Need help on this.
If my assumptions are correct, you may try like:
rangesum(above(total If(Flag='Yes', sum(Sales)/sum(Total Sales)),0,RowNo(Total)))
Screenshot is good while explaining your issue. However, sharing the actual file (here excel) would be better since that would allow people here to try out few things with the data in the course of proposing a possible solution to your query.
Hi,
I've added the worksheet. Let me know if you need any other information.
Can I assume that you are trying to achieve this in a table chart , and 'Cumulative Flag%' is what you need to get?
If my assumptions are correct, you may try like:
rangesum(above(total If(Flag='Yes', sum(Sales)/sum(Total Sales)),0,RowNo(Total)))
Thank you so much. This worked as expected.😊