• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Duplicate Value not shown in pivot table and Sum of total not display while filtering data.

Nitesh Khot

Member
Hi,

Attached file contains data ..Pivot table duplicate value not shown and if i filter data then last column heading not shown.

kindly suggest me.


Regards,
NItesh
 

Attachments

  • Sales Order Details - Open SOs.xlsx
    20.5 KB · Views: 1
Hi,

Refer sheet 2 in the attached file. Duplicate values are not shown because the parameters you have selected in the pivot are the same. If you want to see the duplicate value just insert the Quantity row. The same is added by me in sheet 2 in the attached file. The last column heading is visible even after applying the filter.
 

Attachments

  • Sales Order Details - Open SOs.xlsx
    25 KB · Views: 3
No tricks, I just applied the pivot.
I guess you have changed something in the heading, as you heading is not generated by the pivot that was the reason for heading disappearing when you filter.
 
Back
Top