Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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.
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)