This content has been marked as final. Show 2 replies
I have very small requirement.
I have to create a prompt (SQL Type) where I have display below values in the prompt ( I am able to create a prompt).
Top and Bottom Ten
Top and Bottom Twenty
And another prompt which I would have to display measure name
Based on these two prompt selection I would have to show Top Ten, Twenty,Bottom Ten,Twenty ...etc
Dimension Measure M1or M2 or M3 or M4 ...
D1 Measure Value
D2 Measure Value
D3 Measure Value
Can some one would help me or suggest how would I do this in 126.96.36.199.1
All the Measures M1 to M5 are columns in my Fact table