Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to create a pivot table in NPrinting but am having issues with a dimension not showing all the values. The report was imported to NPrinting in straight table format. But am getting issues achieving this because the quarter dimension only shows one value. It does not show all four quarters. Thanks for your suggestions
Ok - you have only shown me a pivot table. Obviously to built pivot table you first need to produce a straight table with the data.
Hi @Pomna
as usual - to get an answer or hint what could be wrong you should provide us with screenshot of your source data, template, results and mock-up of what you are trying to achieve. We are not there with you and cannot see what you are doing wrong.
Topic you are describing seems quite basic so I assume there is either something not supported breaking it or simple mistake when creating template.
Below is a screen shot of what I expect my pivot table to look like and what I get. The quarter dimension loses all its values. I expect to see Q1, Q2, Q3 and Q4.
Ok - you have only shown me a pivot table. Obviously to built pivot table you first need to produce a straight table with the data.
Thank you the link you provided was of great help but I ran in to other issues. Calculated columns are giving me the #DIV/0! Error message.
Column 3 is column 2/ column 1
Column 6 is column 5/ column 4
Column 8 is column 7/ column 6
Any suggestions on how to fix this?
Hi,
The #DIV/0! error is typical excel error when you try to divide by 0. There is nothing more to add to it.
I repeat again - to give you meaningful information we need to see full picture of all steps you are doing. You are not providing those steps to us so our answer is only based on what we can see.
Side note:
Based on your screenshots I can see 1 strange thing: