[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

İlgili Gönderiler	Cevaplar	Görünümler
Is there a way to modify Pivotview? pivot	1 Tem 24	29
Pivot by Day / Week / Month / Quarter / Year, xml file path? pivot	0 Mar 20	1914
How to add number of record on a pivot table pivot	1 Ara 19	4651
widget inside a pivot view widget pivot	1 Haz 25	741
Is there a way to aggregate pivot data by a specific UoM? reporting pivot	0 Oca 24	1827

Bu soru işaretlendi

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