← Back to team overview

dhis2-devs team mailing list archive

Re: Pivot table data reporting

 

Thanks Ola and Lars,

Yes it is working now . Earlier it was not select as data dimension .

Regards
Sumudu


On Wed, Aug 19, 2015 at 11:16 AM, Ola Hodne Titlestad <olati@xxxxxxxxxx>
wrote:

> Dear Sumudu,
>
> Method 2 should work. Note that you cannot use the data elements details
> option then. You will get your 'type of surgery' disaggregation as a
> separate dimension in analytics that you can see appearing as a new menu
> item in the left side menu and that you can put on columns in the layout
> selection. Then select your data elements as before, but in 'total' mode,
> not details. Put data elements on rows. The gender dimension you don't
> touch as you want all of those collapsed.
>
> Ola
> -------
> On 16 Aug 2015 4:53 pm, "sumudu weerasinghe" <sumuduw00@xxxxxxxxx> wrote:
>
>> 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>
>>>
>>>
>>
>> _______________________________________________
>> 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
>>
>>

PNG image

PNG image


References