Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys,
What I'm trying to do is count the number of customers that have purchases greater than 3 dates in a bar chart. The problem is when I did that I had no dimension but I want the user to be able to lasso each bar to select that group of customers.
Any other ideas on how to accomplish this one?
There are three expressions
=Count (DISTINCT {$<[Invoice Date] = {"> 39400"}>} [Customer Number])
=Count (DISTINCT {$<[Invoice Date] = {"> 39500"}>} [Customer Number])
=Count (DISTINCT {$<[Invoice Date] = {"> 39600"}>} [Customer Number])
It needs to look like this
Hi Kristen,
See enclosed. Something quick and not-so-dirty.
Rakesh
Hey Rakesh,
Thanks for doing that for me. Sorry I should have mentioned that the end user needs to be able to change the three dates on the fly without having to do a reload.