Is it possible to have a Pivot Table with Data Elements associated with different Combination of Categories?

Support - Assistance technique
1

Hi all,

Is it possible to have a Pivot Table with Data Elements associated with different Combination of Categories? If not, is there a way to create a single report with multiple Report Tables?

Regards,

Paulo Grácio

2

Hi Paulo,

one solution would be, in data elements section, to switch from “Totals” to “Details”. Now you can select freely from data element + category option combinations and insert them into your table, irrespective of which category combination they belong to.

Lars

···

On Mon, Jul 22, 2013 at 9:33 PM, Paulo Grácio pgracio@criticalsoftware.com wrote:

Hi all,

Is it possible to have a Pivot Table with Data Elements associated with different Combination of Categories? If not, is there a way to create a single report with multiple Report Tables?

Regards,

Paulo Grácio

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

3

Hi Lars,

Where do I switch from “Totals” to “Details”, I can’t find that option.

Regards,

Paulo Grácio

···

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: segunda-feira, 22 de Julho de 2013 21:48
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Is it possible to have a Pivot Table with Data Elements associated with different Combination of Categories?

Hi Paulo,

one solution would be, in data elements section, to switch from “Totals” to “Details”. Now you can select freely from data element + category option combinations and insert them into your table, irrespective of which category combination they belong to.

Lars

On Mon, Jul 22, 2013 at 9:33 PM, Paulo Grácio pgracio@criticalsoftware.com wrote:

Hi all,

Is it possible to have a Pivot Table with Data Elements associated with different Combination of Categories? If not, is there a way to create a single report with multiple Report Tables?

Regards,

Paulo Grácio

Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

4

Ops that feature is in latest development version but not in 2.12 I can see now. Sorry about that. You might want to run latest version if you are in prototyping phase and not in production.

http://apps.dhis2.org/dev/dhis-web-pivot/app/index.html

···

On Mon, Jul 22, 2013 at 10:34 PM, Paulo Grácio pgracio@criticalsoftware.com wrote:

Hi Lars,

Where do I switch from “Totals” to “Details”, I can’t find that option.

Regards,

Paulo Grácio

From: Lars Helge Øverland [mailto:larshelge@gmail.com]

Sent: segunda-feira, 22 de Julho de 2013 21:48
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Is it possible to have a Pivot Table with Data Elements associated with different Combination of Categories?

Hi Paulo,

one solution would be, in data elements section, to switch from “Totals” to “Details”. Now you can select freely from data element + category option combinations and insert them into your table, irrespective of which category combination they belong to.

Lars

On Mon, Jul 22, 2013 at 9:33 PM, Paulo Grácio pgracio@criticalsoftware.com wrote:

Hi all,

Is it possible to have a Pivot Table with Data Elements associated with different Combination of Categories? If not, is there a way to create a single report with multiple Report Tables?

Regards,

Paulo Grácio

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

5

Thanks Lars, I’ll give it a try with the snapshot version!

···

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: segunda-feira, 22 de Julho de 2013 22:40
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Is it possible to have a Pivot Table with Data Elements associated with different Combination of Categories?

Ops that feature is in latest development version but not in 2.12 I can see now. Sorry about that. You might want to run latest version if you are in prototyping phase and not in production.

http://apps.dhis2.org/dev/dhis-web-pivot/app/index.html

On Mon, Jul 22, 2013 at 10:34 PM, Paulo Grácio pgracio@criticalsoftware.com wrote:

Hi Lars,

Where do I switch from “Totals” to “Details”, I can’t find that option.

Regards,

Paulo Grácio

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: segunda-feira, 22 de Julho de 2013 21:48
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Is it possible to have a Pivot Table with Data Elements associated with different Combination of Categories?

Hi Paulo,

one solution would be, in data elements section, to switch from “Totals” to “Details”. Now you can select freely from data element + category option combinations and insert them into your table, irrespective of which category combination they belong to.

Lars

On Mon, Jul 22, 2013 at 9:33 PM, Paulo Grácio pgracio@criticalsoftware.com wrote:

Hi all,

Is it possible to have a Pivot Table with Data Elements associated with different Combination of Categories? If not, is there a way to create a single report with multiple Report Tables?

Regards,

Paulo Grácio

Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp