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..
Please find following attachment...
when i select calls offered field(its a expression field) in straight table i have to display pivot table.
Hi chandini, I don't know a way to control clicks on expression, anyway, as a click on expression selects the dimensions associated with that cell, you can set the condional show in design tab like:
GetSelectdCount(Date)=1 and GetSelectdCount(Region)=1 and GetSelectdCount(City)=1and GetSelectdCount(Category)=1 and GetSelectdCount(Subcategory)=1
If you want to hide straight table you can use something like:
GetSelectdCount(Date)<>1 or GetSelectdCount(Region)<>1 or GetSelectdCount(City)<>1 or GetSelectdCount(Category)<>1 or GetSelectdCount(Subcategory)<>1
One way to accomplish this is to use a macro and a variable (note, this will work in Ajax mode as well). Assume your Straight table has ID = CH01 and your Pivot table has ID = CH02. Do the following:
Sub NoOfRows
set chart = ActiveDocument.GetSheetObject("CH01")
ActiveDocument.Variables("vRowsCH01").SetContent chart.GetNoOfRows, true
end Sub
Again change CH01 into the real ID of your straight table everywhere.
$(vRowsCH01) = 1
Once more, change CH01 into the real ID of your straight table.
That's it.
Peter