topic Re: set analysis help in App Development

set analysis help

CHEWBAKA — Wed, 15 Apr 2020 13:24:29 GMT

Hello everybody,

I newbie on set analysis and need some help .

I've creat a cross table like this

		Business unit 1	Business unit 1	Business unit 1
DIMENSION:TAG1	DIMENSIOn:SUBTAG1	ValueX	calculatevalue1=ValueX/totalValueTAG1
	DIMENSIOn:SUBTAG2	ValueY	calculatevalue2=ValueY/totalValueTAG1

DIMENSION:TAG2	DIMENSIOn:SUBTAG3	ValueZ		"HELLLPPP"

For the calculatdevalue1 I use this formula: calculatevalue1=Sum(VALUE)/Sum(total{<TAG={"TAG1"}>}VALUE)

It's working fine.

I'm stuck on "HELLLPPP".

I would like tu have valueZ/"total sum of TAG1 by Business Unit".

I'd try something like:

Sum({1}{<TAG={"TAG2"}>}Value)/Sum({1}{<TAG={"TAG1"}>}Value)

Sum({$}{<TAG={"TAG2"}>}Value)/Sum({$}{<TAG={"TAG1"}>}Value)

but it's not working.

Does anyone have some tips?

Thank you.

Re: set analysis help

tresB — Wed, 15 Apr 2020 13:47:45 GMT

I have a tip here for you. This is possibly not a problem of Set Analysis, but TOTAL qualifier or may be combination of both. Check here : TOTAL qualifer for better understanding.

Perhaps you just need a single expression like:

Sum(VALUE)/Sum(total <TAG>} VALUE)

If this doesn't help, try to share your sample app.

Re: set analysis help

CHEWBAKA — Thu, 16 Apr 2020 13:22:58 GMT

thank you for the reply.

it's still not work the expression Sum(total <TAG>} VALUE) always return thetotal/ total of the first TAG (not the total of the first tag by Business unit).

it's close to be resolve ...

regards