I have an spreadsheat, let's say A,B,C,D and E with the amount
A,B,C, are unique, but D happens more than once (4 times) for each D the E amount is the same,
I want to sum up all D records, with just 1 E for them (not 4)
i don't want to delete any position from the pivot table data source
anyone has an idea?
can you set your data field (E) to Average, rather than Sum?
It will give me average of total data,Originally Posted by XLent
For example if i have 400 records, with 130 unique D and E, i want sum the average of unique records
SUM E and then divide by COUNT OF E?
If you need this done in calculated field, you'll need to add helper column on source table (each row having 1).
Then divide SUM of E by SUM of Helper.
(i.e. 'E Column'/'Helper Column'. Since PivotTable's calculated field performs sum of all rows in context, before any other calculations are performed)
Alternately you can use DAX formula if you can add the table to data model.
Last edited by CK76; 05-02-2019 at 09:20 AM.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks