Dynamic Dimension in lines

[wunderch]

Hi,

i have the following problem.

I have a Table like this:

Product	Sales	Cost 1	Cost 2
Jackets	100	20	50
Shoes	200	40	100

Now when I select for example Jackets I have to show it in a diagramm like this:

Dimension
Sales	100
- Cost 1	20
Result 1	80
- Cost 2	50
Result 2	30

Thanks for any ideas

Chris

[jeffmartins]

Hi,

You can create two tables and set the show condition to hide the first table when the product jackets is selected and show the second table. The show condition is on layout tab in the chart properties.

The condition for the first table could be GetSelectedCount(Product) <> 1 and for the second table GetSelectedCount(Product) = 1.

Regards

[MayilVahanan · Accepted solution]

Hi

Are you expected like the attached file. (ValueList sheet)

Hope that helps

[wunderch]

Hi,

this is EXACTLY what I expected!

Thank you very much for the quick answer!!