Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have a Date selection object on a sheet. User can select only "single" date at any given time on the filter pane. We have a Text & image object which should reflect previous Quarter based on the date selected on the filter pane.
Example1:
Date selected (Field Name = "Start Date") = "04/01/2018" (MM/DD/YYYY)
Previous Quarter should show " 1st Quarter 2018"
Example2:
Date selected (Field Name = "Start Date") = "02/01/2018" (MM/DD/YYYY)
Previous Quarter should show " 4th Quarter 2017"
Thanks,
H
Sure. You can do so using set analysis
Use something like below
Sum({<OrderDate={">=$(=quarterstart(AddYears(Max(OrderDate),-1))) <=$(=quarterend(AddYears(Max(OrderDate),-1)))"}>}LineSalesAmount)
Thanks for the response. It is not applicable here as no aggregation is required here.
What are you trying to display then? a single dimension?
Similar concept can be used but with only function instead of other aggregation functions