Analytics Software

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

Thanks
sayak