5 Replies Latest reply on Jul 11, 2019 11:27 PM by koushik.neelakantha

# PY Sales WRT Month & Quarter

Hi everyone,

Requirement:

If i select 2019 from year parameter my CY will be 2019 and PY will be 2018. If i select Month/quarter ,my Previous year(2018) should not get change. only my CY values(2019) should get change. Even though if i select Month & quarter, my 2018 values should show for entire year.

Same with year parameter 2018.If i select 2018 from year parameter my CY will be 2018 and PY will be 2017. If i select Month/quarter ,my Previous year(2017) should not get change. only my CY values(2018) should get change. Even though if i select Month & quarter, my 2017 values should show for entire year.

Regards,

Koushik.

Zhouyi Zhang

Mahfooj Khan

• ###### 2. Re: PY Sales WRT Month & Quarter

hi Koushik,

Refer attached workbook.

Thanks

sankar

• ###### 3. Re: PY Sales WRT Month & Quarter

Hi rajan, thank you.could u please send me the logic with steps as i am unable to download the workbook.

Sankarmagesh Rajan

Regards,

Koushik

• ###### 4. Re: PY Sales WRT Month & Quarter

Hi

Create year parameter and quarter parameter

Sales CY

sum(If [Year]=[Year Parameter] and [Quarter]=[Quarter Parameter]

then [Sales]

elseif [Year]=[Year Parameter] and [Quarter Parameter] ='All'

then [Sales]

end)

Sales PY

{ FIXED [Quarter],[Month]: sum(if [Year]=[Year Parameter]-1 then [Sales] END) }

now show year and quarter parameter.

drag both cy and py in view and get selected year and qtr and month in cy.

py will always show overall year sales.

1 of 1 people found this helpful
• ###### 5. Re: PY Sales WRT Month & Quarter

Hi ,can anyone help me out with above scenario without using quarter parameter and fixed expression.

I am facing granularity issue while using quarter and month for fixed.

Mahfooj Khan

Zhouyi Zhang