10 Replies Latest reply: May 5, 2016 9:00 PM by Sunny Talwar

# Partial sums only for some values in one dimension

Hi,

I would like to know how to achieve the below requirement.

I have a dimension, Payer Group which has 5 values like 'Commercial, Medicaid, Medicaid HMO, Tricare, PAP. The first 4 values fall under different group. So I need to calculate partial sums to the first 4 values and the total also should be placed for all.

Kindly help me with this.

Thanks,

Ramesh.

• ###### Re: Partial sums only for some values in one dimension

Seems to me you need more dimensions here. One for year, one for quarter, one for "Payer Group Group", with one value for the four, and one for the other. Then just do regular old subtotals. That gives you one subtotal you don't need for the payer group group with a single payer group, but you can collapse the dimension so that you don't see the duplicate.

• ###### Re: Partial sums only for some values in one dimension

Hi John,

Could you please let me know how to create a group one for "Payer Group Group", with one value for the four, and one for the other.?

Thanks,

Ramesh.

• ###### Re: Partial sums only for some values in one dimension

[Payer Group Groups]:

Payer Group Group, Payer Group

Something, Commercial

Something, Medicaid

Something, Medicaid HMO

Something, Tricare

PAP, PAP

];

Or left join that onto your main table. Or make it a mapping load and map in the values.

I did exactly this sort of thing with product groups in an application yesterday.

• ###### Re: Partial sums only for some values in one dimension

Hi John,

Thank you very much. Sorry for the delay in reply.

I will try this and let you know.

Thanks,

Ramesh

• ###### Re: Partial sums only for some values in one dimension

Hi John,

My apologies for the late response.

I am still working on this, but unfortunately unable to find the logic behind it.I need to create a pivot table as it is seen in the screenshot.

In the attached report,

Total Pd/Ship ---- is derived based on sum of Commercial, Tricare, Medicaid, Medicaid HMO.
Total Month is the entire total based on all the columns.

• ###### Re: Partial sums only for some values in one dimension

I need the logic how to add the Total Pd/Ship columns to that table.

• ###### Re: Partial sums only for some values in one dimension

Just a quick note to say I'm swamped at work, but I've not forgotten you. I probably won't be able to look at this until next week. If it's urgent, I hope someone else will be able to help you.

• ###### Re: Partial sums only for some values in one dimension

Perhaps move this out of the NPrinting discussion forum and into a more suitable one?

• ###### Re: Partial sums only for some values in one dimension

May be we can help you better if you are able to provide the raw data behind the chart. Without knowing what all things are available, it would be slightly difficult to create a sample.