(Region / Monthly Sales) |
January |
February |
All Regions |
… |
… |
|
|
|
All Online Stores |
… |
… |
|
|
|
Philippines |
… |
… |
|
|
|
Austria |
… |
… |
In my dataset, Online Store are a type of store every country has. In the Region dimension. Online Store has dimension#=1 and Countries has dimension#=2. Pick() is used to show both Online Stores and Countries.
The problem is that All Stores will double count Online Stores, once from the Region 'Online Store', and then from each region.
Is there anyway to prevent double count?