Right click your 'Completed within SLA' row field, and choose 'Field Settings'. Choose the 'Layout & Print' tab, then tick the [] 'Show items with no data' box. Click OK. Sorted.
If you want to show zeroes instead of blank cells, right click the pivot table, choose 'Pivot Table Options', and untick the [] 'For empty cells show:' box.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks