Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I wanted to show the data for only January Month in the pivot table for the respective year.
for ex if I select year 2017 then the table should show me the values for 2017 Jan month irrespective of month selection.
Please find attached file for reference.
Hi,
In Set Analysis you can set the Month =1
Like below:
Expression:
=Avg({<Continent = {'Asia','Europe','North America'},Month={'1'}>} Actual)
Hi,
In Set Analysis you can set the Month =1
Like below:
Expression:
=Avg({<Continent = {'Asia','Europe','North America'},Month={'1'}>} Actual)