|How Do I Hide certain detail and column areas in a crosstab? [message #987604]
||Tue, 27 November 2012 10:13
| holy moly
Registered: June 2012
I've been struggling to hide certain detail columns I do not wish to show in my cross tab.
The report will show the row data: name X...
with the column detail... 1 Month, 3 Months etc...(ordered by a begin date which is hidden)
the Detail holds values Net1, gross1, excess1 stacked above eachother then
Net2, Gross2, Excess2 again stacked above each other to the right of Values1 and will show for each period
I only wnat to show the second group of values for specific periods.
Ive tried filtering at the crosstab level but lose everything
tried at the cell level but only hides the values contained within the cell
I want to remove/hide the entire column when the frequency equals the desired frequency period to show the data
Name ----- Perod 1, Period 2, period 3
Name ----- Vals1 vals1 Vals1 Vals2
I've managed to control the display as in it will only display values and header for the correct period but can't hide the entire column when the period is not correct
Hope someone can point me in the right direction
[Updated on: Tue, 27 November 2012 11:26]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.02020 seconds