Removing column from pivot table visual

Question & Answer
, , ,
1

I need to generate this report where I have:

  • Account Number
  • Name
  • Address among other information.

In my dataset, account number, name, and address can appear multiple times because the same account, name, and address can have different attributes. However, in my visual, I need to ‘aggregate’ the identical data and only display the unique values in rows.

For example, in the attached screenshot, I have a single account 8486, the same name, the same address, but four different values. I managed to achieve this visual using a pivot table, which gives me what I need, but I can’t exclude or remove the count column.

I tried with formatting conditionals but also can’t change the color of the “Count” column.

All my fields are in the rows dimension, I have nothing on columns or values.

QS
QS2376×824 81.6 KB

Any suggestions or recommendations on how I can solve this problem?

2

@mariana Pivot table should have at least one measure value. If no values added then Pivot table will add count column by default. There is no option to exclude or hide.
You can try changing the value position to rows and turn off any totals or sub-totals
image

This will remove the label Count from table and you change the font color to white to hide the text. This is only to hide column and value.

At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request.