ignore 1 dimension in the set analysis??

[Anonymous]

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

[Anonymous · Accepted solution]

Found the solution!!!!

sum( total <MainConfig> value)

[#3]

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

[pljsoftware]

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.