topic Re: % of total expression -- need to keep static after filtering in App Development

% of total expression -- need to keep static after filtering

jalanhart — Tue, 02 Apr 2024 22:18:13 GMT

I have a measure in a table calculating Year To Date sales, and I want to make a measure that shows the % of each dimension row compared to the total YTD sales.

my expression that gets the correct % is this :

[YTD CURRENT YEAR] / Sum(all {<INVOICE_DATE={">=$(=Date(YearStart(Max(INVOICE_DATE))))<=$(=Date(Max(INVOICE_DATE)))"}>} NET_AMOUNT)

the % numbers turn out correctly, but if i select one customer for example, the value changes to 100%. I need it to stay the % of all total, not just filtered.

How can I fix this?

Re: % of total expression -- need to keep static after filtering

marcus_sommer — Wed, 03 Apr 2024 12:43:12 GMT

You could add those fields within the set analysis, like:

sum({< F1, F2, F3 = {'x'}>} Value)

which means the selections of F3 are overwritten and those from F1 and F2 are ignored and everything else would be considered.

Re: % of total expression -- need to keep static after filtering

jalanhart — Thu, 04 Apr 2024 00:28:46 GMT

Hi Marcus, thanks for your help,

that wouldn't quite get to me to where I wanted to go, but I think I was able to tentatively get it by using this here:

[YTD CURRENT YEAR] / Sum( all {1<INVOICE_DATE={">=$(=Date(YearStart(Max(today()))))<=$(=Date(Max(today())))"}>} NET_AMOUNT)