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