Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I need your help to create a condition,
if any particular client has less that N (variable that I enter) records in any given month, and then take off this client from the table completely.
Please see my attached file.
I need 3 lines in my chart:
1st shows TOTAL (all clients who have more than Variable2)
2nd - INDUSTRY (all clients in selected INDUSTRY who have more than Variable2)
3rd - CLIENT (selected Client who has more than Variable2).
Please see my attached file.
I added 3 tables, which show the right result, if I select N=10 and Industry=eee and Client=B
avg({ $< Client=, N_Month={">$(=Variable2)"}>}[TC]) it was an idea to calculate all client in selected Industry.
If I select Client, Industry and Client lines are the same.
I don't know how select them
Please help me to add condition ignore Selected
Client=,
avg({$<Client={"=Min(aggr(Sum(N_Month), MYear, Client))>$(Variable2) and (count(total<Client> distinct MYear)=count(total distinct MYear))"}>}[TC])
is it possible to create variable which will use only selected Clients.
than use this variable in expression somehow