• 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.

Pivot table showing count of date in percentage

B

binod2u

New Member
How to show or calculate or add calculated field to show progress as shown in yellow highlighted in excel sample on Pivot table.
 

Attachments

  • Pivot table-Show result in percentage of date count.xlsx
    123.4 KB · Views: 4
Since you were using PowerPivot some simple DAX may work.
Simply divide the count measures.
59767
 

Attachments

  • Copy of Pivot table-Show result in percentage of date count.xlsx
    160.7 KB · Views: 12
You must log in or register to reply here.
Back
Top