Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am facing an issue in straight table while adding up the previous YTD value with current monthly value. I find out the value but not able non aggregate at different dimension level. I am attaching the source screen shot and expected output screen shot Please help me to achieve this issue it is urgent.
Any help will be appreciated !
Thanks deepak
What if you remove CODE as dimension?
Hi tresesco,
It add both the values of MTD and YTD columns if I removed Code from the table.but I want to add the value only of MTD column means I want to aggregate ONLY MTD values not YTD .Please find the attached screenshot for your reference.
Try expression for MTD something like:
Sum(Total <Category> YourMeasure)
I tried Not worked.
Try to share a sample qvw to work on.
Hi,
Please find attached sample file.
Regards
deepak
Hi Tresesco,
Please reply its urgent.
Thanks,
deepak