Forum Discussion

BalaKrish's avatar
BalaKrish
Icon for Helper I rankHelper I
4 years ago
Solved

Sum The Calculation Items when Multiple Items are selected in Slicer

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....
  • Anonymous's avatar
    Anonymous
    4 years ago

    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