Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

[Payer Group Groups]:

LOAD * INLINE [

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.

View solution in original post

9 Replies
johnw
Champion III
Champion III

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.

Not applicable
Author

Hi John,

Thanks for the reply.

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.

johnw
Champion III
Champion III

[Payer Group Groups]:

LOAD * INLINE [

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.

Not applicable
Author

Hi John,

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

I will try this and let you know.

Thanks,

Ramesh

Not applicable
Author

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.

Could you please assist me.

Your help is much appreciated.

Not applicable
Author

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

johnw
Champion III
Champion III

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.

Daniel_Jenkins
Specialist III
Specialist III

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

sunny_talwar

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.