I didn't use "as of now" since its single simple excel table and attached the sample.
I tried with range sum above function for the second expression(Dot or line chart), but it's not working since it considering the dimension and I tried avoiding the dimension again it's not showing the correct value.
=RangeSum(Above( total Sum( [Quantity]),0,12))
what happening is jan2019 should has the value from Feb 2018 to jan2019 but it's taking only Jan2019 as starting value
script is below
load *, date(date#(Month_Year,'MMM-YY'),'MMM-YY') as Month_Year1; LOAD Year(date#("Reporting Year",'YY')) as Year, date(date#("Reporting Period",'MMM'),'MMM') as Month, date(date#("Reporting Period",'MMM'),'MMM')&'-'&Year(date#("Reporting Year",'YY')) as Month_Year,
Quantity from xxx path.
Period_Type: Load * Inline [ Period 12 Months Rolling YTD Monthly ];
chart is combo
date(Month_Year1,'MMM-YY')->last 12 months
exp 2 as a dot or line above mentioned and
exp1 as a bar and its month-wise data and variable already explained.
Attached my qvf file where the Jan 2019(exp2) starting point has 72.9 it has only Jan19 month value(this is the roadblock), but it should have sum of value-form feb18 to Jan 19, this will have a clear picture to you. kindly help me with this
many Thanks, sunny for your solution it's a great help
I implemented the same, the values are getting accurate.
But facing one more issue, I m getting the dimension value from Jan 2017 to Dec 2019, I avoided the dim limit as per your qvf and given no limitation and data handling disabled the include zero values but it's coming with Jan 2017 to Dec 2019. kindly help me with this so that my requirement will be accurate.