It is possible to put a subtotal inside a dimension?

[#1]

Dear all,

I haven't posted anything in a while, now I'm seeing this new forum design... is great!!!

Now, to what matters:

In the attached file, you can see that I have already designed a Pivot Table with results of certain indicators in several categories. But as a requirement from my employeers, I need to put a subtotal row only for certain categories that should not affect the total result. Is there any way to accomplish this?

I guess my question should be better understood seing the attached file.

As usual, thanks for any comments.

[#2]

hi Andres,

Can u attach a sample script used for the above solution.. We are also having the same scenario here...

Thanks in Advance..