Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have 24 months in barchart.
but want to show last 12 months only
how to limit the dimension?
PFA
You can use set analysis in expression something like Sum({<Month = {">=$(=Max(Month)-12)"}>}Value)
Hi,
PFA
Thanks,
AS
Hello!
try this set analysis: sum({<DATE={">=$(=addmonths(max({1}DATE),-11))"}>} VALUE)
Dear Digvijay
if i selected the Week 15 mean i have the 24 weeks
but 1 st 12 weeks are history weeks last 12 weeks are forecast weeks
i want to show the last 12 weeks only
my expression is
=num(sum({<Year_UP = {$(=Max(Year_UP))},Week_UP={$(=Max(Week_UP))}>}Sales),0.00)
I think you should check this, every thing is mentioned here?
Dear amit.saini
i am using personal edition only so i cant open your QVW files
Select limit of values:
Go to dimension limit select option and the give the value there than it show only that values .
i want to show last 12 weeks only