cancel
Showing results for 
Search instead for 
Did you mean: 

How I can show some calculated field with information out of filter scope

Former Member
0 Kudos

Example: You do some filter of especific year(2016 for example) and I need that calculated field show the another year(2015 for example) information out of that filter you did.

Accepted Solutions (1)

Accepted Solutions (1)

varunanand
Contributor
0 Kudos

Hi Jezer,

When you filter the year you would not able to get the result you desire, as you will be limiting the data to only 2016. Thus the 2015 data will not be available to visualize.

A similar scenario which I faced was to display a rolling 24 month chart. This means that if I select July 2016, I should be able to see data from Aug 2014-July 2016. This can be developed as formulas in Lumira or the best would be to create queries in the backend system.

I can set the month/quarter/year selection with Refresh on Prompts as shown below,

Then we can make the corresponding date selection as Variables,

This would give me a dynamic date range based on my selection.

Please let me know if there are any questions or comments.

Thank you,

Varun Anand

Former Member
0 Kudos

Hi Varun,

Thank you a lot, I will try and I will reply to you if its work for my need.

see later,

Jezer Portilho

Answers (1)

Answers (1)

TammyPowlas
Active Contributor
0 Kudos

Not sure I follow; have you tried it with your data?  Also see this SAP document: