Set analysis question

[fredericvillemi]

Hi,

i have a document with many dimensions : project, customer, dimension1, dimension2

i want to create a chart with an amount total which will be always the amount total for the selected "project" without looking at any other dimension.

I mean, i want to have the total only based on one filter, project

how can i do that with set analysis  (or with another way) ?

Thanks

[#2 · Accepted solution]

sum({1<Project=P()>} Field)

[#3]

Hi Frederic,

I think this can be done by using the following expression :--

sum({<customer=,dimension1=,dimension2=,project=$(=only(project))>}field)

[v_iyyappan]

Hi,

     use like this

      = sum(TOTAL field)

Regards

Iyyappan

[fredericvillemi]

Great, exactly what i wanted

and imagine i would like to add another dimension, how can i do it ?

only project and customer ?

Thanks

[#6]

That is simple, just copy the syntax with a coma after to add more:

sum({1<Project=P(),customer=P()>} Field)