4 Replies Latest reply: Mar 19, 2018 10:14 PM by Roger Bielicke

# Selecting Only Current Year Data for KPI

Beginner 101 questions:  How do I filter a KPI to just show the Current Year Data?  There is a Time Dimension with CY & PY for Current & Prior Year - see bar chart below.  When I select the measure for the KPI view it is summing both the CY & PY.  How do I set up to only sum the Current Year in the KPI then show a 2nd measure for the % change of CY Conversions / PY Conversions?

Thank you!

• ###### Re: Selecting Only Current Year Data for KPI

can you explain a little bit more?

• ###### Re: Selecting Only Current Year Data for KPI

Current

Sum({<CY={1}>} Conversions)

Previous

Sum({<PY={1}>} Conversions)

• ###### Re: Selecting Only Current Year Data for KPI

I think that u have a dimension "Time" containing 2 Values? CY and LY?

then in ur KPI, for CY

change ur measure

from:

sum(Measure)

to

for current

sum({<Time={'CY'}>}Measure)

for last

sum({<Time={'LY'}>}Measure)

• ###### Re: Selecting Only Current Year Data for KPI

Thanks Omar.  That did it.  Appreciate the 101 lesson.