This topic contains 3 replies, has 2 voices, and was last updated by 
-
Posts
-
hi,
I need to know how to perform these calculations (measure) in Power Pivot
see Picture
%E – % of Total Column
%R – % of total line
tks,
Please explain what the column on the left is for. Is that for customer names or location names or something else? Also you covered over information at the top of several columns, but I assume that represents the date or month or quarter of sales. I do not need to know what its value is, but it would be helpful to what it is a value for.
How about putting the data in a workbook and posting with your next comment?
Without that information, I can say that you will probably be using functions like CALCULATE, FILTER, HASONEVALUE, ALL, SUM and DIVIDE.
Following information
left column = dealer or seller
upper column = product brand
see Picture_1
Still request data in workbook.
The forum ‘Power Pivot’ is closed to new topics and replies.