← Back to team overview

dhis2-devs team mailing list archive

Re: Pivot table data reporting

 

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


Follow ups

References