Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 dimensions: MainConfig and Config
With the expressions I have ope of the expressions which should show a precentage over the sum of the MainConfig, which means I want to ignore the Config dimention.
Is it possible to ignore only 1 of the dimensions??
I know that sum({1} total value) ignores all dimensions but that exactly not what I need.
any suggestions?
Anita
Found the solution!!!!
sum( total <MainConfig> value)
Anita
Thanks for posting your solution. I had a very similar problem where I needed to ignore a dimension in a pivot chart, and your post put me on the correct track to solve something that has been bugging me for a while!
Regards
Adrian
Hi,
to ignore a filed in a set analysis you must to write this
sum({1<Field= >} Quantity)
Ignore field is permitted from simbol =
Total doing a group by a field.