Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi expert,
My data only have the snapshots for each quarter end e.g. 2017Q1, 2017Q2, 2017Q3 ...
I need to do some basic comparsion as quarter to quarter or year to year for specific month.
Should I build a hierarchy table or a calendar table for it?
Any tips?
Hi,
Can u explain elaborate or can you explain with sample data?
I think Calendar Table is enough for this question. If you really need hierarchy - How this works?
Could you provide data sample?
As comparison of months do not go along with quarterly information.
Thx all. Attached is the workings data sample.
I may need to do comparsion e.g. 2018Q1 Vs 2017Q1 between the YTQ_TOTAL_NOP figures for Bank under Company A
or 2018Q2 vs 2018Q1 of CQ_TOTAL_NOP.
COMPANY_NAME | TYPE | QUARTER | YTQ_TOTAL_NOP | CQ_TOTAL_NOP | YTQ_ANP_USD | CQ_ANP_USD | YTQ_ANP_HKD | CQ_ANP_HKD |
Company A | Bank | 2017Q1 | 2,503 | 2,503 | 35,350 | 35,350 | 275,729 | 275,729 |
Company A | Bank | 2017Q2 | 5,021 | 5,021 | 73,476 | 73,476 | 573,112 | 573,112 |
Company A | Bank | 2017Q3 | 7,797 | 7,797 | 115,379 | 115,379 | 899,959 | 899,959 |
Company A | Bank | 2017Q4 | 9,856 | 9,856 | 145,849 | 145,849 | 1,137,626 | 1,137,626 |
Company A | Bank | 2018Q1 | 1,561 | 1,561 | 39,372 | 39,372 | 307,101 | 307,101 |
Company A | Bank | 2018Q2 | 3,011 | 3,011 | 79,585 | 79,585 | 620,762 | 620,762 |