filtering one part of a combo plot

[#1]

Hi,

I have a combo plot (line and bar plot). I want to filter the data that generated the bar plot and NOT the line plot.

X	Y	Z	V
11	0.5	0.8	A
22	0.4	0.45	B
33	0.3	0.7	A

The plot has been created using the following:

X as Dimension

Y as Experssion (Line plot)

Z as Expression  (Bar plot)

The expression for Z is basically a frequency: =(Count(X)/count(ALL(X)))*100

What I want to do do, is filter the calculation of Z based on the value of V, i.e., only calculate Z for the rows where V='A'

does it make sense to write the expression as follows:

=(Count({<V={'A'}>} X)/count({<V={'A'}>}ALL(X)))*100

Thanks.

[Anil_Babu_Samineni · Accepted solution]

I am not following you, But by luck you can use TOTAL keyword rather ALL

=(Count({<V={'A'}>} X)/count({<V={'A'}>} TOTAL X))*100

What I want to do do, is filter the calculation of Z based on the value of V, i.e., only calculate Z for the rows where V='A'

What you mean, Z based on the value over here?

[#3]

I want to calculate Z i.e., the frequency here, ONLY based on the rows where V='A'.

Does the expression used actually return what I actually want?

What is the difference between Total and ALL ?

[Anil_Babu_Samineni]

Here is the link for 3rd question - Keywords : TOTAL, ALL &amp; DISTINCT

Second question, How come we know whether what is business?

First question? Yes, If your frequency expression correct then off course, The condition true

[#5]

from the explanation, I think total is what I want.

As in my case, the division in the Frequency should be calculated ONLY based on the count of rows where V='A'.

[Anil_Babu_Samineni]

Deserve It !!!