"Last Selected Month" Values in a Column without using procedure

Mira Slaouti

Hi everyone,
I would like to create a Layout with a column that contains the data from the last month selected in the screen without using the procedure with step "apply selection to layout block"
I tried to use the "Last Value" Option but in case that the data are null for the last selected month , I had the last non Zero value
Thanks in advance for your help 

Mira

Brendan Broughton

Hi @Mira SLAOUTI depending on the data and the months you're selecting you might be able use an approach like the below to get what you need (without having to use a procedure to dataflow.

I actually have calendar year 2020 selected, but the cube I want to show only has data to July 20. I only want to show data for the latest month (with data), ie. July, but with the full year selected.

The top dataview is the raw data, the bottom is with 'last value' applied.  The third/small/right hand dataview is using a few things to only show the last month.  The bottom snip shows the layout setup in the third dataview, all blocks other than the last are hidden.

In this instance blocks A/B/F are the same, just with 'total by' set on A and B, and 'offset = 1' set on block B.  Depending on how your screen selections are working and the data in the cube you want to display you may need to set A and B up differently.  But the same approach should work.  You'll just need to be mindful of screen refresh rates.

Let me know if that helps or if you want any more information.

------------------------------
Brendan
bbroughton@bi5.com.au
Australia
------------------------------
-------------------------------------------