Hi all,
In attached file, i need percentage column in the pivot table.
Percentage = Column C/Column B i.e. No. of Incidents / No. of batches
Can someone please help?
Hi all,
In attached file, i need percentage column in the pivot table.
Percentage = Column C/Column B i.e. No. of Incidents / No. of batches
Can someone please help?
Added three measures to the data model.
Count of Batch Month:=COUNTA(Table2[Batch Month])
Count of Incidents:=COUNTA(Table2[Tickets])
Percentage:=[Count of Incidents]/[Count of Batch Month]
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Perfect. Many many thanks JeteMc.
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks