exporting text report - must have a value field

Hello, John!

Thank you for reaching out to us.

Kindly note that measures are required in the pivot table, as its main function is to aggregate data at the intersection of each member in the rows and columns.
Could you please check out our example of the flat table view and let us know if this can be the data visualization you are looking for?

Regarding your comment about the attachments, we haven't received any additional screenshots in our inbox yet. Please note that you can attach a zip archive with all images to the ticket if necessary.

Looking forward to hearing from you.

Kind regards,
Solomiia

Hello, John!

Thank you for your swift response and for the provided attachments.

We have noticed that you have already customized your Excel export to add a company logo. Please note that unnecessary columns can be as well removed from a unit8Array in the export handler.

There are also a couple more approaches on how to achieve the desired behavior:

• Use a flat table layout, where you can create the data visualization without measures: https://jsfiddle.net/flexmonster/3gbpsarn/.
• Use customizeCell function to set cell captions for values as empty strings. This won't modify the data underneath, but the values won't be visible as the sum of "Price" in the following example: https://jsfiddle.net/flexmonster/kwyx6rn5/.

Hope you will find our answer helpful.

Kind regards,
Solomiia

Hello, John!

Hope you are doing well.

Our team is wondering if you have some time to check out our previous response. Could you please let us know if you have any further questions?

Looking forward to hearing from you.

Kind regards,
Solomiia

Hello, John!

Hope you are having a great week.

Just checking in to ask if our answer was helpful in hiding the column in the Excel export.

Looking forward to hearing your feedback.

Kind regards,
Solomiia