How Do I Hide certain detail and column areas in a crosstab? [message #987604] |
Tue, 27 November 2012 10:13 |
holy moly Messages: 2 Registered: June 2012 |
Junior Member |
|
|
Hi,
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
eg
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
Thanks,
B
[Updated on: Tue, 27 November 2012 11:26] Report message to a moderator
|
|
|
|
Powered by
FUDForum. Page generated in 0.03570 seconds