Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Anyone can help me how to create a line chart for this measure :
sum({$<TAHUN = {"$(=max(TAHUN))"}, YEAR_MONTH_CAL>} COMM_ORIG_AMT_IDR_PLF)
-
(sum({$<YEAR_MONTH_CAL = {"$(=max(YEAR_MONTH_CAL))"}>} BALANCE_IDR) - sum({<TAHUN={$(=max(TAHUN)-1)},NUM_BULAN_C={12}, YEAR_MONTH_CAL>}BALANCE_IDR))
Thanks
Add a line chart object to your sheet. Choose a field to use as dimension and add that to the chart. Then add your expression as chart expression. Done.