Forum Discussion
Filtering calculation group items
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 🙂
- MonsterJoe
CG's come with the order by column defalut name: "Ordinal". By default it's a hidden column. If you un hide it you can put it in the filter pane and by choosing there you can filter only the related CI's.
Okay - I get it. As we have no way to create a relation to the "Ordinal" column there really isn't any grouping or filtering options.
Thanks for clarifying.
MonsterJoe
No problem.
- MonsterJoe