Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
With month as dimension, I want to show previous month data in each month. If I use variable, it shows in two lines. I need to see in one line. Please advice.
Regards,
Ruchi
Message was edited by: Ruchi Bagaria
Can you please share an example what you are trying to achieve and would be great if you can add a sample QVW file
Hi Punit,
I have attached a sample app with sample source data. And thanks for the response.
Regards,
Ruchi
two line, do you mean in two different columns?
and you need it to have both Previous month stock and Current month stock in a single column?
May be use this for Previous Month for your Pivot Object
=sum({<MonthYear = {"$(=Date(Max(MonthYear-1),'MMM-YYYY'))"}>}[Total Stock])
Or By using Variable you may try this
=sum({<MonthYear = {"$(=vPrevMthNo)"} >}[Total Stock])
Hi Anil,
I had tried both. The problem is, the sata comes in two rows. I want it be in a single row.
Regards,
Ruchi
Hi Friends,
I could solve it. I just had to take the Price from Dimension as put it as a measure and it worked. Hence, closing the discussion. Thanks for your responses.
Regards,
Ruchi
try using aggr function like below :
=aggr(sum({<MonthYear={'$(vPrevMthNo)'}>}[Total Stock]),[Planning Article])
=Aggr( sum([Total Stock]),[Planning Article])
Hi ruchibagaria
Please mark response from above as helpful/correct answer to closed the thread
Thanks
What do you meant by single row here, can you describe more your intend to look
I got like below, What was the expect from here