Oprichnick
Board Regular
- Joined
- May 30, 2013
- Messages
- 69
Hello,
I want to create a pivotchart in which I want to show only the % of one item from its subtotal.
Using % parent I can easily calculate the %, however when I filter only that item it returns 100%. Of course, because now the subtotal is only summing its values.
In the below example: I want to have a chart/table in which I filter only "b" and what I have is the "b"%.
I thought about creating a calculated fields, but I am not being able to do it... What would be the best solution in this situation?
<tbody>
</tbody>
<tbody>
[TD="align: right"][/TD]
[TD="align: right"][/TD]
</tbody>
I want to create a pivotchart in which I want to show only the % of one item from its subtotal.
Using % parent I can easily calculate the %, however when I filter only that item it returns 100%. Of course, because now the subtotal is only summing its values.
In the below example: I want to have a chart/table in which I filter only "b" and what I have is the "b"%.
I thought about creating a calculated fields, but I am not being able to do it... What would be the best solution in this situation?
1 | 2 | |||||||
a | b | c | 1 Subtotal | a | b | c | 2 Subtotal | |
x | ||||||||
y | ||||||||
z |
<tbody>
</tbody>
Thanks in advance | |||||||||
Pedro |
<tbody>
[TD="align: right"][/TD]
[TD="align: right"][/TD]
</tbody>