Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use exp likr this
if(sum(total(<HoldingCampany>Revenue)>VRevenue),Count(Distinct---),null())
Sorry Guys...
Both of those are just giving me the old " - " in my text box.