Count function based on chart variable

[#1]

Hi all,

I've developed a pivot displaying revenue by customers (and other dimensions)

This is linked to an input box for "Show customers with rev above: variable"

It works perfectly for the chart and limits it as it should, but I also display a box on the screen with a count of customers in the current selection.

As this variable is not actually selecting the customers (just supressing view) the count is not updating.

So I could have three in my pivot but still be saying 46'732 customers in selection .

I've tied the following but so far have been unable to jiggle it correctly.

='# of Holding Companies in Selection  '&

Count(IF(Sum(TOTAL(<[Holding Company]>Revenue) > VRevenue),[Holding Company]))

I want to count (distinct if poss.) Holding Company, if the revenue at the holding company is greater than VRevenue

Any ideas ?

Thanks

T

[sujeetsingh]

Use exp likr this

if(sum(total(<HoldingCampany>Revenue)>VRevenue),Count(Distinct---),null())

[#3]

Sorry Guys...
Both of those are just giving me the old " - " in my text box.