Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have application that I would like to show totals and only respect the year filter. The year filter is defined as Year(EventDate). Current I am using the formula below to ignore all selections except the year filter with limited success.
Sum({1< EventDate =P(EventDate)>} Days)
It seems to ignore selections with the year but starts to break down on certain selections if multiple years are selected. Any thoughts on how I can improve this formula?
Try like:
Sum({1< EventDate =$::EventDate>} Days)
For better understanding you may refer the document I wrote : Ignore all selections except few fields using Set Analysis
Try this :
Sum({<field1,field2,field3,field4.... >} Days)
No encuentro otra manera, o que hagas una tabla flotante solo para ese grafico y lo relaciones mediante el calendario.
Saludos!!!
I was thinking something more along the lines of GetFieldSelections with set analysis.
Try like:
Sum({1< EventDate =$::EventDate>} Days)
For better understanding you may refer the document I wrote : Ignore all selections except few fields using Set Analysis
Elegant solution and a great article!