Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
reshma_km
Partner - Creator III
Partner - Creator III

Excel pivot table - NPrinting 17.3

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?

2 Replies
Chanty4u
MVP
MVP

can you show the picture?

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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:

  • what you are doing
  • what is your result
  • what is expected result

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.