Hello Gurus,
I have a dashboard report which has YTD and monthly values. Now I got a new requirement of a metric which has different calculation for monthly and YTD. If I get the values of monthly (metric a_monthly) and YTD (metric a_YTD) from the database itself, can I show the values in a row in the crosstab? The metrics are as rows in the crosstab. But the requirement is to show YTD and monthly values of the metric in a row. If I pull from database, it actually creates to metrics. If I pull these two metrics(a_monthly and a_YTD) in crosstab, it will show 2 rows. Instead, I want to show them in a row. my model is DMR. Not sure how to perform this. I know how to hide columns, but here I have to take the monthly values of a_monthly metric and YTD value of a_YTD metric and merge these two and show it in a row in a crosstab.
Please help me in this regard. I need it urgently.
thanks you in advance!