Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi....
I have two tables one is straight tables and pivot table when i select the perticular row of straight table the pivot table should be display(like hide and show).
Can any one help me..
Thanks...
This depends on the dimension of your straight table. If your straight table has one dimension only (which is not calculated but a normal field), then this selection is like selecting a listbox value of this field/dimension:
So you can go in properties of the pivot table > Layout > Show Conditional:
getselectedcount(YourField)>0 - so everytime a selection is made, the pivot table is shown
You can use the value of the diemsion you using in your table and then set triggers.
You can set trigger Document Properties>> Triggers>>Triggers on field
and then set the action
This depends on the dimension of your straight table. If your straight table has one dimension only (which is not calculated but a normal field), then this selection is like selecting a listbox value of this field/dimension:
So you can go in properties of the pivot table > Layout > Show Conditional:
getselectedcount(YourField)>0 - so everytime a selection is made, the pivot table is shown
Here is the sample for you
Hi..
Thnks for your reply can we show pivot table based on the expression field in straight table(not based on the dimension field).
Please find following attachment...
when i select calls offered field(its a expression field) in straight table i have to display pivot table.
Thnks,
Chandini.G
I think this is not possible but maybe someone else has an idea...might be worthy to post this in a new thread
Hi Daniel..
Thanks for your responce.i posted in new thread..
Thanks,
Good luck