How to select a constant view of selected customers from one month going forward?

[Anonymous]

Hi All,

I have 2 tables that join on a  masterkey.

The master key is created by : client number x month

eg: if a camp was in Jan 2016(1601)  and the client number was 1, the masterkey = 1601.

The first table:

Camp_name

M_key

Second table:

M_key

client_number

spend

month

I am trying to produce a graph that will show a client and how thier spend changed following the camp.

I want to be able to select the camp, and the graph will only show those clients that went on that camp and the spend for those clients across all months worth of data that we have.

I tried this in the graph as it is kinda what I want to see once a selection of the camp is made:

=SUM({<client_number={$},month={1}>}[Spend])

Any help will be awesome!

Thanks in advance.

[Anonymous]

The work around that I can currently use to get the output I want.

Select the camp I want.

Select the client numbers in the listbox 'client_numbers'.

Then deselect the camp.

I would like to do the above with just a selection of the camp.

[tresesco · Accepted solution]

Try:

=sum({<camp,client_number=p(client_number)>} spend)

[Anonymous]

That is it!

I had never heard of the P() or E() functions.

Thank you!