Skip to Main Content

Displaying dynamic columns in table, based on dashboard prompt selection

sayakSep 25 2012 — edited Sep 25 2012
Hi ,

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 !!!!