tanquoc0309
New Member
- Joined
- Aug 16, 2013
- Messages
- 27
Hi all
<tbody>
</tbody>
I created pivot table (powerpivot) with slicer Store.
How can I create a calculate in powerpivot that show Average of Region when I filter Store, such as:
When I choose store "A", the formula will show average of region "N"
When I choose store "C", the formula will show average of region "N"
Thanks,
Store | Sale | Region |
A | 10000 | N |
B | 20000 | N |
C | 30000 | N |
D | 15000 | S |
E | 19000 | S |
<tbody>
</tbody>
I created pivot table (powerpivot) with slicer Store.
How can I create a calculate in powerpivot that show Average of Region when I filter Store, such as:
When I choose store "A", the formula will show average of region "N"
When I choose store "C", the formula will show average of region "N"
Thanks,