Displaying dynamic columns in table, based on dashboard prompt selection
sayakSep 25 2012 — edited Sep 25 2012
I have a pivot table (one variable dimension column against revenue measure) & a dashbaord prompt (having 3 dimesion choices - Product,Entity,customer segment) .
So , Based on the prompt selection my pivot table dimension columns will get changed .i.e , if i initially have revenue against product , after selectiing Entity from prompt , table will dynamically gets changed to revenue against Entity .
FYI , when I say dimension column , I am pulling all members of them , i.e the whole hierarchy .
A similar impleamentation will also help me .
Waiting for your replies !!!!