# Data Visualizer - Pivot table download empty - when category options (all) selected in rows \[FIXED\]

**URL:** <https://community.dhis2.org/t/data-visualizer-pivot-table-download-empty-when-category-options-all-selected-in-rows-fixed/54449>\
**Category:** Support - Assistance technique\
**Created:** [14 August 2023 16:09 UTC](https://community.dhis2.org/t/data-visualizer-pivot-table-download-empty-when-category-options-all-selected-in-rows-fixed/54449 "2023-08-14T16:09:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jthomas](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jthomas/32/32752_2.png) [@jthomas](https://community.dhis2.org/u/jthomas)\
**Post date:** [14 August 2023 16:09 UTC](https://community.dhis2.org/t/data-visualizer-pivot-table-download-empty-when-category-options-all-selected-in-rows-fixed/54449/1 "2023-08-14T16:09:13Z")

</div>

When we create a pivot table in data visualizer app, in 2.38.x or 2.39.x, selecting category options (automatic/all) option, reports get downloaded as empty eventhought it has data in data visualizer.

I was able to simulate this in play dhis2. Below are the steps, just curious do we already have a jira for it, or **do we have any work around for it.** especially when we have thousands of category options, manually selecting is also not working it selects around 50 items at a time.

Steps to reproduce:

1. Go to play dhis2 2.38.x or 2.39.x Data Visualizer
2. Take Anc 1st Visit and second visit as data
3. Include category option Location Fixed/Outreach - Automatic /all into rows section of data visualizer like screenshot below
4. Download as xls or csv it gets downloaded an empty report with a header  
 ![image](https://dhis2.b-cdn.net/uploads/default/original/3X/2/d/2d9255dce3b3d890f5016d2d6a051f0d0cd6cf69.png)

 ![image](https://dhis2.b-cdn.net/uploads/default/original/3X/a/b/abc7d50ad6d22c874e9f4a2c839270e721ef6873.png)

**Downloaded empty report**

 ![image](https://dhis2.b-cdn.net/uploads/default/original/3X/0/5/05283dd251ecaaeaec863745b1ff629eb95c0468.png)

---

<div class="post-metadata">

**Author:** ![Gassim](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/gassim/32/35347_2.png) [@Gassim](https://community.dhis2.org/u/Gassim)\
**Post date:** [14 August 2023 16:43 UTC](https://community.dhis2.org/t/data-visualizer-pivot-table-download-empty-when-category-options-all-selected-in-rows-fixed/54449/2 "2023-08-14T16:43:04Z")

</div>

Hi @jthomas

This has been reported in this Jira bug issue: [[DHIS2-15044] - Jira](https://dhis2.atlassian.net/browse/DHIS2-15044) and its status is that it has been fixed and backported. To double check that this issue is fixed in the upcoming stable releases you can try to reproduce the issue here: [https://play.dhis2.org/2.39dev](https://play.dhis2.org/2.39dev) 🙂

Thank you for the detailed and clear post. It really helps! 🙏

---

<div class="post-metadata">

**Author:** ![jthomas](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jthomas/32/32752_2.png) [@jthomas](https://community.dhis2.org/u/jthomas)\
**Post date:** [14 August 2023 16:50 UTC](https://community.dhis2.org/t/data-visualizer-pivot-table-download-empty-when-category-options-all-selected-in-rows-fixed/54449/3 "2023-08-14T16:50:51Z")

</div>

Thank you so much @Gassim i tested in 2.39dev, it looks fixed. Looking forward for this release.

---

<div class="post-metadata">

**Author:** ![Gassim](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/gassim/32/35347_2.png) [@Gassim](https://community.dhis2.org/u/Gassim)\
**Post date:** [14 August 2023 16:51 UTC](https://community.dhis2.org/t/data-visualizer-pivot-table-download-empty-when-category-options-all-selected-in-rows-fixed/54449/4 "2023-08-14T16:51:59Z")

</div>

Always happy to help @jthomas 🙏

Thanks! (: