Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my Nprinting excel report, I am creating an excel pivot table from qvf data. Now above the table headers I want to have another header row. I created a formula for the same whose value is a static string like "current time". But when I drop the formula on the cell above the pivot table header, the value is not displayed. Only the formula name( <formula_name>) appears. But if I place the same formula in a cell outside the pivot table columns, it is coming correctly. How can I correct this?
can you show the picture?
My understanding is that Pivot tables are created based on existing data.
What you are trying to do is to enter a value in Pivot Tabel (not editable) area - that will never work.
As sugested by Chanty - provide a screenshot of:
regards
Lech