Hello everyone!
I have a problem considering that technique - Dynamic Charting In Power Pivot « PowerPivotPro
When I create a hierarchy in PP it contains duplicated names on the lower levels due to logic below:
<tbody>
</tbody>
So therefore it produces a problem after switching. For instance, when I switch a slicer to Categories it contains duplicated categories - in this example all four above, twice notebooks, twice software. But I expect to get only unique names and sums for them.
Any ideas how to solve it?
I have a problem considering that technique - Dynamic Charting In Power Pivot « PowerPivotPro
When I create a hierarchy in PP it contains duplicated names on the lower levels due to logic below:
Brands | Categories | Subcategories |
Apple | Notebooks | 1 edition |
Microsoft | Notebooks | 2 edition |
Apple | Software | 1 edition |
Microsoft | Software | 2 edition |
<tbody>
</tbody>
So therefore it produces a problem after switching. For instance, when I switch a slicer to Categories it contains duplicated categories - in this example all four above, twice notebooks, twice software. But I expect to get only unique names and sums for them.
Any ideas how to solve it?