Pivot table - Columns with different dates

[dushkee]

Hello 

i have pivot table and i need to add a column, where will be data only for a selected date period (from-to) and this column shouldnt consider the date selected in filter. 

Is there any possibility to fix the date in column1, column2 etc and the last row will be according to filter?

thanks

[mfchmielowski]

Hi.

You can use datePickers and two variables. First DatePicker will set value to variable startDate and second DatePicker will set value to endDate variable. Then in expression of the pivot you can use SetAnalysis expression:

count({< dateColumn={">=$(dateStart)<=$(dateEnd)"} >} column)