Current Month V Previous Month

[mohiahmed]

Hello,

I need some help with a query and any help would be greatly appreciated.  Trying to show current month v previous month as calculations and finding it difficult.  Table 1 I have main numbers and table 2 I am trying to show the difference and don't know where I am going wrong.

Table 1

Table 2

Query in expression is sum({<[Reporting Month]={">=$(=monthstart(today()))"} >} ['MI Requirement Volumes'])-sum({<[Reporting Month]={">=$(=monthstart(today(),-12))"} >} ['MI Requirement Volumes'])

Regards

Mohi

[sunny_talwar]

You will either have to use Missing Manual - Before() and After() or use The As-Of Table

[vinieme12]

TRY

sum({<[Reporting Month]={">=$(=monthstart(today()))"} >} ['MI Requirement Volumes'])-sum({<[Reporting Month]={">=$(=monthstart(addmonths(today(),-1)))"} >} ['MI Requirement Volumes'])

[mohiahmed]

Thanks for the Vineeth, however I only get attached result now.

[sunny_talwar]

I have feeling it is not going to work vinieme12‌ because Date is one of the dimension. So this would show two columns, 1) for 01/01/2016 and another one for 01/01/2015 and will never put them in one column unless we use Before.

[mohiahmed]

Thanks for that Sunny.Tying to get my head round this Sunny bit finding it difficult. Need to do more reading around it.

[sunny_talwar]

If you are able to share a sample, we might be able to help you better here

[mohiahmed]

Hi Sunny, this is my load script

SQL

SELECT `Calculation Type`,
Customer,
`Customer System ID`,
`First Period End Date`,
`FM Description`,
`FM ID`,
`FM Type`,
Frequency,
`GAG Indicator`,
`Group ID`,
Model,
`Number of Text Components`,
`Number of Tick Components`,
`Number of Work Items per Annum`,
`Post GAG TtC DG`,
Region,
`Relationship Owner`,
`Reporting Month`,
SBU,
Team,
Type
FROM `353_Stock`
WHERE ((([353_Stock].SBU) Not In ('BA&SF')));

[sunny_talwar]

When I said sample, I meant your qvw file and not your script my friend. This script is not very helpful for me as I cannot run this and create the same visual like yours

[mohiahmed]

Aha, ok sorry matey;  Let me send it over.