Not able to non-aggregate the value at different dimensions in straight table

[#1]

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

[tresesco]

What if you remove CODE as dimension?

[#3]

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.

[tresesco]

Try expression for MTD something like:

Sum(Total <Category> YourMeasure)

[#5]

I tried Not worked.

[tresesco]

Try to share a sample qvw to work on.

[#7]

Hi,

Please find attached sample file.

Regards

deepak

[#8]

Hi Tresesco,

Please reply its urgent.

Thanks,

deepak