Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've list whose values are like this
VARIABLE |
X |
y |
z |
I've a table
X | Y | Z | VALUE |
P | T | L | 100 |
P | T | M | 101 |
P | U | L | 102 |
P | U | M | 103 |
P | V | L | 104 |
P | V | M | 105 |
P | W | L | 106 |
P | W | M | 107 |
Q | T | L | 100 |
Q | T | M | 101 |
Q | U | L | 102 |
Q | U | M | 103 |
Q | V | L | 104 |
Q | V | M | 105 |
Q | W | L | 106 |
Q | W | M | 107 |
R | T | L | 100 |
R | T | M | 101 |
R | U | L | 102 |
R | U | M | 103 |
R | V | L | 104 |
R | V | M | 105 |
R | W | L | 106 |
R | W | M | 107 |
S | T | L | 100 |
S | T | M | 101 |
S | U | L | 102 |
S | U | M | 103 |
S | V | L | 104 |
S | V | M | 105 |
S | W | L | 106 |
S | W | M | 107 |
Now i Need a chart where the dimension is selected by the list and expression is SUM(VALUE)
For ex: If is select X in the list, i should have a chart where Dimension is X and Expression is SUM(VALUE)
How can achieve something like this?
Hi,
Have a look at the attached example.
Regards,
Kaushik Solanki