Button or Switch for Difference and % Variance Calc

Hi all,

I would like a button or selector that gives the user the ability to switch between difference and variance. Any idea how to approach it?

Thanks Maik

Find more posts tagged with

Accepted answers

Helmut Heimann

Hi @Maik Burghardt ,

I'd use a cube holding a "1" for difference and a "0" for variance (or vice versa). Maybe you want to have a user dimension in this cube as well, so that users don't interfere with each other.

Place that cube DE enabled on the screen (switch off headers, etc.) and in your dataview (hidden), and let the user choose their option.

According to the user's option choice create an algorithm in your dataview that either shows algo1 or algo2.
Only thing is that you need to come up with a proper heading for that column (perhaps something like (diff/var). Keep in mind that you shouldn't use anything like "symbol after".

Best,
Helmut

All comments

Helmut Heimann

Hi @Maik Burghardt ,

I'd use a cube holding a "1" for difference and a "0" for variance (or vice versa). Maybe you want to have a user dimension in this cube as well, so that users don't interfere with each other.

Place that cube DE enabled on the screen (switch off headers, etc.) and in your dataview (hidden), and let the user choose their option.

Maik Burghardt

Thank you Helmut. I like that idea.