Hi,
I created measure "MAT" in pivot table. After I add it into values area MAT measure is repeating for each column label (quarter). Is it possible to move this measure MAT only at the end of table (just new column at at the end)? In pivot table I could use Calculated Item and I get new column at the end.
[TABLE="class: grid, width: 1256"]
<tbody>[TR]
[TD][/TD]
[TD]Column Labels[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Sum of Podatek o količini prodaje[/TD]
[TD]MAT[/TD]
[TD]Sum of Podatek o količini prodaje[/TD]
[TD]MAT[/TD]
[TD]Sum of Podatek o količini prodaje[/TD]
[TD]MAT[/TD]
[TD]Sum of Podatek o količini prodaje[/TD]
[/TR]
[TR]
[TD]5 mg/1,25 mg[/TD]
[TD]65[/TD]
[TD]356[/TD]
[TD]109[/TD]
[TD]356[/TD]
[TD]96[/TD]
[TD]356[/TD]
[TD]86[/TD]
[/TR]
</tbody>[/TABLE]
This is what I want (from pivot tables):
[TABLE="class: grid, width: 622"]
<tbody>[TR]
[TD]Sum of Podatek o količini prodaje[/TD]
[TD]Column Labels[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]MAT[/TD]
[/TR]
[TR]
[TD]5 mg/1,25 mg[/TD]
[TD]65[/TD]
[TD]109[/TD]
[TD]96[/TD]
[TD]86[/TD]
[TD]356[/TD]
[/TR]
</tbody>[/TABLE]
If anyone know an answer please help me
Thanks,
Andrej
I created measure "MAT" in pivot table. After I add it into values area MAT measure is repeating for each column label (quarter). Is it possible to move this measure MAT only at the end of table (just new column at at the end)? In pivot table I could use Calculated Item and I get new column at the end.
[TABLE="class: grid, width: 1256"]
<tbody>[TR]
[TD][/TD]
[TD]Column Labels[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Sum of Podatek o količini prodaje[/TD]
[TD]MAT[/TD]
[TD]Sum of Podatek o količini prodaje[/TD]
[TD]MAT[/TD]
[TD]Sum of Podatek o količini prodaje[/TD]
[TD]MAT[/TD]
[TD]Sum of Podatek o količini prodaje[/TD]
[/TR]
[TR]
[TD]5 mg/1,25 mg[/TD]
[TD]65[/TD]
[TD]356[/TD]
[TD]109[/TD]
[TD]356[/TD]
[TD]96[/TD]
[TD]356[/TD]
[TD]86[/TD]
[/TR]
</tbody>[/TABLE]
This is what I want (from pivot tables):
[TABLE="class: grid, width: 622"]
<tbody>[TR]
[TD]Sum of Podatek o količini prodaje[/TD]
[TD]Column Labels[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]MAT[/TD]
[/TR]
[TR]
[TD]5 mg/1,25 mg[/TD]
[TD]65[/TD]
[TD]109[/TD]
[TD]96[/TD]
[TD]86[/TD]
[TD]356[/TD]
[/TR]
</tbody>[/TABLE]
If anyone know an answer please help me
Thanks,
Andrej