Forum Discussion

Prasad1's avatar
Prasad1
Helper I
8 years ago
Solved

Using Cumulative Sales Total, Cumulative % values

Hi   I have Product Code, Sales Volume Privot report with Sales volumes posted against each SKU across 12 months till Last month. I have to generate running totals at Product code level, calculate ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    And here is the measure for Cumulative %age

    Cumulative_%age =
CumulativeBI[Cumulative_Total]
    / CALCULATE (
        SUM ( CumulativeBI[Sales Volume] ),
        ALL ( CumulativeBI[Product Code] )
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

And here is the measure for Cumulative %age

Cumulative_%age =
CumulativeBI[Cumulative_Total]
    / CALCULATE (
        SUM ( CumulativeBI[Sales Volume] ),
        ALL ( CumulativeBI[Product Code] )
    )
Prasad1's avatar
Prasad1
Helper I
8 years ago

Hi Zubair Muhammad

 

Brilliant Solution. Yes. It worked beautifully.

 

Thank you very much for your help.

 

Regards

Prasad