Hi,
Is it possible to create groups by variables in pivot table?
Variables are loading from excel file.
| | Group1 | Group2 |
Dimension1 | Dimension2 | `=$(Variable1) | `=$(Variable2) | `=$(Variable3) | `=$(Variable3) | `=$(Variable2) | `=$(Variable3) |
Value | Value | Sum(Value) | Sum(Value) | Sum(Value) | Sum(Value) | Sum(Value) | Sum(Value) |
Value | Value | Sum(Value) | Sum(Value) | Sum(Value) | Sum(Value) | Sum(Value) | Sum(Value) |