Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
my second post.
I have a ytd table with set analysis to calculate the ytd based on the selected month.
As seen I selected the Dec.
I used a fiscal year starting at Oct.
The set analysis is:
SUM({<Kategorie={'Instore'},[Auftragsdatum.aC.Date]={"<=$(=max([Auftragsdatum.aC.Date]))"}, [Auftragsdatum.aC.Month]=>}[Versand nach Retouren Netto])
In the right column i calculate max() of the date.
The dimension is FiscalYear
When i select Dec, the max(date) shows correctly, but the YTD calculted only the max(date) of all dates and not per Dimension (=FiscalYear)
Can I let the calculated variable calulate by dimension "on-time"?
Thanks
We must mapped Fiscal table to Fact Date table, Then only it will associate each. I apologies, If i misunderstand the requirement.