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.
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.
Very cool!
MonsterJoe check out AlexisOlson solution.
Didn't believe you can actually add a column to a CG table, so didn't even think of trying that 😆
Hi AlexisOlson
Really nice approach! I will process in that direction.
BTW - do you guys have any feeling about how large a calc group can be in terms of number of items - with regard to performance? Having the option to group and filter will give great dynamic possibilities (in combination with calc group scripting) - especially if the limit on items is high.
I have not experimented with massive calculation groups, but I don't have any reason to believe that the number of items is particularly important so long as you are only using a limited number at any given time. Obviously, if you're trying to use lots of items all at once, then you have to actually compute each of them.
