Attached herewith is a sample .qvw.
Please do have a look at it, I have placed a comment in the script to explain what is my desired results
test1.qvw 126.8 K
You can Use this script to derive difference between no. of users for current month minus Previous month.
LOAD * INLINE [
Year, Quarter, MonthOfYear, UniqueChargedUsers
2012, 2, 5, 22030
2013, 4, 12, 58521
2014, 1, 1, 72378
2014, 1, 2, 52969
Order by Year, MonthOfYear;
Drop Table Source;
if((Year = Peek(Year) and MonthOfYear = Peek(MonthOfYear) + 1 ) or(Year = Peek(Year) + 1 and MonthOfYear = 1 and Peek(MonthOfYear) = 12 ),UniqueChargedUsers-Peek(UniqueChargedUsers)) as DiffrenceOfCurrentAndPreviousMonth
Drop Table Source1;
Result will be like this.