Skip to Content
0
Former Member
Jul 01, 2015 at 04:01 PM

YTD and Current month calcuation in same Graph/Table for the dimension values

31 Views

Hi Team,

We have a requirement to display the Bar chart with YTD and Current month in the same.


We did the YTD but for the current month we are stuck.


Report is based on the HANA view based universe; we have the variables defined in HANA view directly and no variable in Webi or Universe.

When running the report the date is filed is poulated as shown below; but on single variable "Posting date" both 'Start Value' and 'End Value'.

The mesure 'amount' should display based on the 'End value' from the user Input.

Raw materials Amount YTD Amount Current month (05/15 based on the above example) RM1 44000 1200 RM2 76888 3400 RM3 89000 4500

Also, we do have a dimension called 'Month'.

Acheived YTD using the formula "=([Amoun])/Count([Month])"


How to achieve the current month based on the variable from HANA veiws?

Thanks

San

Attachments

Capture.PNG (41.6 kB)
Capture.PNG (41.6 kB)