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

Hi Prasad1

 

Here is the measure for Cumulative Total

Cumulative_Total =
VAR Currentsales =
    SUM ( CumulativeBI[Sales Volume] )
RETURN
    SUMX (
        FILTER (
            ALL ( CumulativeBI[Product Code] ),
            CALCULATE ( SUM ( CumulativeBI[Sales Volume] ) ) >= Currentsales
        ),
        CALCULATE ( SUM ( CumulativeBI[Sales Volume] ) )
    )
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Add above measure in CumulativeBI table

     

    • 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