[V14] Defining an action to open a pivot with comparision feature

Question

I would like to define in xml (view and/or action parameters) a pivot view of leads, comparing the current year revenue with the previous year one , i.e. using the date filter and comparision with previous year.
That's because I would like to make the year dynamic (i.e. always comparing the current year with the previous year), I know i can save thes filter and recall it but it would always display the same years.

Digital Domus s.n.c. · Answer

It works for the filtering part, but it doesn't automatically apply the comparision feature.

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
You can open the pivot view with action and add a dynamic filter to achieve what you require.
Here is an example which adds a dynamic filter on date.

Hope it helps

Related Posts	Odgovori	Prikazi
Is there a way to modify Pivotview? pivot	1 jul. 24	29
Pivot by Day / Week / Month / Quarter / Year, xml file path? pivot	0 mar. 20	1840
How to add number of record on a pivot table pivot	1 dec. 19	4509
widget inside a pivot view widget pivot	1 jun. 25	565
Is there a way to aggregate pivot data by a specific UoM? reporting pivot	0 jan. 24	1668

This question has been flagged

Enjoying the discussion? Don't just read, join in!