V
vw
I have a simple pivot table with two filter criteria at the top and then two
fields of information to be displayed in the rows below once a user has
selected the criteria at the top. I have it all working but have two more
visual problems:
1. The filter criteria at the top display the field names to the left of the
drop down selection cell and I just want the selected values to show at the
top in the middle of the pivot table preferably.
2.the first value I select on the row level has "Row Label" as the header at
the top is there a way I can force it to use the custom field name versus
"Row label" ?
3. I want the second value to be in the next column from the first field
however the format keeps putting it below the first value in the row
section...is there a way to make it move to the next column and line up on
the same row as the first value?
any help will be great.
thanks
fields of information to be displayed in the rows below once a user has
selected the criteria at the top. I have it all working but have two more
visual problems:
1. The filter criteria at the top display the field names to the left of the
drop down selection cell and I just want the selected values to show at the
top in the middle of the pivot table preferably.
2.the first value I select on the row level has "Row Label" as the header at
the top is there a way I can force it to use the custom field name versus
"Row label" ?
3. I want the second value to be in the next column from the first field
however the format keeps putting it below the first value in the row
section...is there a way to make it move to the next column and line up on
the same row as the first value?
any help will be great.
thanks