supress zero or null value

[#1]

Hi,

I have a bar cart with 2 series and i want to show the vaue of first series just for last selected dimetions... for example dimention is year and expressions are plan and turn over.... and i want to show plan for all selected year and show just last year turn over...

can you help me?

[#2]

Can you post a sample, so that we can understand better and help you solve it

[rahulgupta]

Hey Hi,

In this case you can perform the following steps:

1.Keep the Expression for 'plan' as it, i.e. no need to change anything in that.

2.In the expression for 'turn over' use set analysis as

sum({<Year={$(=max(Year))}>} TurnOver)

This will show the turn over for the maximum year, even in the selections.

3.Check the check box 'Suppress Null Values' in the Dimention tab.

Hope this works....

[#4]

Hi

tanx for your help.... In this case as you see for the blue seies we see zero value... I want eleminate blue one for all years exept last year...

thanxx

[Anonymous]

Hi S.

Did you try the option "Supress When Value is Null" ?
It's on your Dimension tab @ settings for seleceted dimension.

[#6]

Hey ,

yess....

[Anonymous]

Yess... It's the answer or Yess.. you tried? 🙂

[#8]

Hi Dennis

🙂 I tried but dont get answer....

thanx dear;)

[Anonymous]

Did you also tried this on the Presentation Tab?

There it is called : Supress Zero-Values

[#10]

Dennis

it is working:-) i change chart type from bar chart to line and bar chart and it is done 😉

thanxxxx