I dont understand the req well,
if am correct u want to hide the headers in the pivot table,
u can do it be conditional formating..
select grid mode, right lick the header, select conditional formating, set colors of borders and background to transparent then it is done.
if this is not what u want pls explain ur req..
I have tried with the conditional formatting but i am not able to remove the headers.
Let me explain you clearly..
We have to develop a page where the user data populates accordingly to the user logs in and the respective data has to pop up for the user.
Lets say my field 1 has some data "XYFFFFFDSFSDFD" and field2 has data 3424324324
then data should come as
the above requirement is achieved using a pivot table , If you have any other views of doing it plz let me know...
the size of data for field1 and field2 may vary based on the user posisble data but i should be able to fit properly so that the width of this chart should not exceed 750 (X- Axis : 3 , Width : 750)
Please let me know if you need more details..