Forum Discussion
Helper ISum 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. When multiple options are selected , I want to display the sum of those. Can someone suggest a way to do this?
Thanks in advance!
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
1 Reply
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