Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to find the sum of sales on the first day of the year for all the dates in the table chart.
My table has the date field as the dimension
Date sales on the first day of the year
29/03/2020 ??
28/03/2020 ??
27/03/2020 ??
Could anyone help me with the set analysis?
Perhaps this
Year as Dimension
and expression : Sum({<Date={"$(=Date(Min(Date),'Your Format Here'))"}>} Sales)
Thank you
But i will have to keep the date field as the dimension and for each date i need to find the sum on its yearstart date