can I create a calculation that shows in a pivot table the percent of filter rows?

26 views Asked by At

I created this percent dividing two columns ("Flash"/"Total Orders" for showing in the follow pivot table, the information is correct when I filter in the Market slicer 1 value as the second image. Although, when I select all the Market places I get the sum of all the Market“s percents which is incorrect.

enter image description here

enter image description here

enter image description here

I need that the calculation show the percent = Flash/Total Orders for the filter information in the pivot table without sum it when I filter many Market places for each Business category.

0

There are 0 answers