Sum The Calculation Items when Multiple Items are selected in Slicer

[BalaKrish]

Dear All,

I have a slicer which displays the calculation items from the calculation group,

CalcSlicer

  CalcItem1

  CalcItem2

  CalcItem3

  CalcItem4

User can select multiple options. When multiple options are selected , I want to display the sum of those. Can someone suggest a way to do this?

Thanks in advance!

[Anonymous · Accepted solution]

Hi @BalaKrish,

Did these slicer items include in one table field? If that is the case, you only need to extract the selections and use the 'in' operator in your filter expression.

If they are different formulas, you can check the filter selections and concatenate multiple if statements to summary these calculations.

In addition, can you please share some more detail about your data structures? They should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng