← Back to team overview

dhis2-devs team mailing list archive

Re: Pivot table data reporting

 

Thanks Lars,

I tried in two ways but unable to gain my need ,

1.st  Method, it gives subdivision into gender , i need total of all gender
category, without .
[image: Inline image 2]


2 nd method , also unable to give solution , giving same result as above.

What i need is eg.
 1. no of plastic surgeries (Minor)--- not gender wise categorization


Can we get it through dhis2?

Regards
Sumudu













On Sat, Aug 15, 2015 at 4:19 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>
wrote:

> Hi Sumudu,
>
> yes there are two options:
>
> 1. You can go to the data items > data elements section, the for data
> elements you select "Details" instead of "Totals"
>
>
> [image: Inline image 1]
>
> 2. You can make sure your category is marked as a "Data dimension" in the
> maintenance (make sure to re-run analytics afterwards if you changed it).
>
> You can then use the category in your pivot (from the left side panel),
> select your items and place the dimension on the "rows" from the Layout
> dialog.
>
>
> regards,
>
> Lars
>
>
>
>
>
>
>
> On Sat, Aug 15, 2015 at 8:25 AM, sumudu weerasinghe <sumuduw00@xxxxxxxxx>
> wrote:
>
>> Dear all,
>>
>> We are  using dhis2 , 2.18 for a hospital information system.
>> Data element for theater statistics developed by using category
>> combination of ,  Gender( M,F,Not define) and Type of surgery(Major, minor,
>> intermediate).
>>
>> I need to get report on total for each category   as follows,
>>
>>  eg.
>>
>>
>>
>> Major
>>
>> Intermediate
>>
>> Minor
>>
>> No of general surgeries
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> No of Plastic surgeries
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Is it possible to get such report in pivot table or any other reporting
>> within dhis2?
>>
>> Regards,
>>
>> Dr.Sumudu Weerasinghe
>> Medical officer Health informatics
>> Teaching hospital - Ragama
>> Srin Lanka
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org>
>
>

PNG image

PNG image


Follow ups

References