Forum Discussion

edwardroa's avatar
edwardroa
Helper I
5 years ago
Solved

subtotal by multiple categories

Hi all,

 

Have searched through multiple threads but unable to find the solution. 

 

I'm needing a simple subtotal by 2 categories in the form of a calculated column. As an example, I need the below highlighted result please:

 

 

Thanks in advance, I'm sure it's quite easy but think my brain is fried trying to find the correct solution.

 

Kind regards,

Ed

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Try this calculated column formula

    =calculate(sum(data[liability]),filter(data,data[asset type]=earlier(data[asset type])&&data[year buckets]=earlier(data[year buckets])))

    Hope this helps.

5 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Try this calculated column formula

    =calculate(sum(data[liability]),filter(data,data[asset type]=earlier(data[asset type])&&data[year buckets]=earlier(data[year buckets])))

    Hope this helps.

    • edwardroa's avatar
      edwardroa
      Helper I
      5 years ago

      Thanks Ashish,
      When I get to the "EARLIER" function it doesn't allow me to select the Asset Type or Year Buckets columns?

       

       

      • edwardroa's avatar
        edwardroa
        Helper I
        5 years ago

        Hi Ashish,

         

        I get to the below part of the formula however when I start to type Asset Type, it doesn't bring up Asset Type as a column to select from?