Hi All
I've got a challenge when trying to apply a sum(max()) value to my card as there is a variable I can't identify correctly
In my data (anonymized) I have the following columns I need to use for this:
[Customer], [Model Type], [Model %], [Master Description], [Sub Description]
What I need to do is, when a [Customer] is selected then look at the [Model Type] (Standard or Priority) and apply the SUM(MAX()) [Model %] but when no [Customer] is selected then apply the SUM(MAX()) [Model %] of Standard [Model Type] to all of my data
In my Card (Table) What I would expect to see is when a customer is selected from the Filter the calculation would show the correct % of the summed [Model %] for said customer but if no customer is selected, then it would show the Standard [Model %] as a default
TLDR: When a Customer is selected, apply the MAX aggregation of the [Model %] based on [Model Type] else use [Model Type] = Standard
Apologies if this is badly worded as I'm struggling to find the right way to ask the question on Google to get toward the answer I need but I can elaborate if needed
Thanks for any and all support/responses
Dan