Set analysis

[MindaugasBacius]

Hei,

Can we use calculated expression from pivot/straight table in the same pivot/straight table as a field in Set analysis?

I have tried and it doesn't work.

Maybe I am doing something wrong or maybe it's not possible

[MK_QSL]

can you provide your expression / Calculated dimension please?

[marcus_sommer]

You could include set analysis within the calculation of a calculate dimension - but you need to wrap these expression within an aggr-function, see for this: Calculated Dimensions.

- Marcus

[Kushal_Chawda · Accepted solution]

If i understood correctly , You can do something like this

I am giving just example below, you can change your expression accordingly

1st Expression:

=Sum(Sales{<Typ1={1}>}Sales)

2nd Expression:

=Count({<Dimension ={"=Sum(Sales{<Typ1={1}>}Sales)>0"}>}ID)

If not then explain your scenario

[MK_QSL]

What is =Sum(Sales{<Typ1={1}>}Sales)? kush141087

[Kushal_Chawda]

thats typo or you can consider as State

[MK_QSL]

I will consider as State.. LOL... (Good answer)

[Kushal_Chawda]

But if it is state ,syntax is incorrect. lol.. should be like below i think

Sum({Sales<Typ1={1}>}Sales)