Forum Discussion
Solved
Filtering calculation group items
Hi forum. Does anyone know if it is possible to set up a slicer or filter to do filtration on which calculation group items to show in a report? That would be some kind of dimension that enables th...
MonsterJoe
No problem.Yes, this is possible.
As SpartaBI experienced, I also get an error if I try to create a relationship with a calculation group.
However, a workaround is to add a calculated column to the CalculationGroup table and use that column on a slicer.
Please see the attached as a simple working example.
MonsterJoe
You can use the ordinal column of the calculation group to filter the available Items shown in the report but I don't think as far as I know you can group them. Only to split them to different CG's
Interesting!
Can you elaborate on: You can use the ordinal column of the calculation group to filter the available Items shown in the report
Thank you very much 🙂