Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

How do you create a table and the values are accumulated?

i want to create a table which the values are accumlating (see sample below) but i could not get the correct visual to use. I hope you can help me on this.   PIVOT TABLE: 5/21/2018 1326 231 ...
  • BhairavPalan's avatar
    BhairavPalan
    8 years ago

    1. Check the format

    2. It will solved using Cumm. Total

    Cumulative Quantity :=
    CALCULATE (SUM ( Transactions[Quantity] ),
        FILTER (ALL ( 'Date'[Date] ),
            'Date'[Date] <= MAX ( 'Date'[Date] )))
     
    Hope this helps
BhairavPalan's avatar
BhairavPalan
Regular Visitor
8 years ago

1. Check the format

2. It will solved using Cumm. Total

Cumulative Quantity :=
CALCULATE (SUM ( Transactions[Quantity] ),
    FILTER (ALL ( 'Date'[Date] ),
        'Date'[Date] <= MAX ( 'Date'[Date] )))
 
Hope this helps