Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
[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.
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.
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.
[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.
Hi John,
Thank you very much. Sorry for the delay in reply.
I will try this and let you know.
Thanks,
Ramesh
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.
I need the logic how to add the Total Pd/Ship columns to that table.
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.
Perhaps move this out of the NPrinting discussion forum and into a more suitable one?
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.