Show data for Only January Month

piyush_s11 — Sat, 16 Nov 2024 04:27:28 GMT

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.

Re: Show data for Only January Month

mdmukramali — Thu, 14 Feb 2019 07:10:18 GMT

Hi,

In Set Analysis you can set the Month =1

Like below:

Expression:

=Avg({<Continent = {'Asia','Europe','North America'},Month={'1'}>} Actual)