Remove (blank)

[lordfa9]

I've come up with the following pivotable as attached

Basically my problem is to remove the 2 rows, (blank) and (blank) Total

How do I do it?

[benishiryo]

hi there. i suggest you not use the whole column to reference for your PivotTable. go to your RAWDATA worksheet, and click on cell A1. press CTRL + T to convert that into a Table. press OK.

you can now create a PivotTable and your range is now dynamic. when you add data there, you can simply refresh your PivotTable and it will capture the latest data.

[vanthinh3101]

When using Pivot Table, you should use Table data or Dynamic Range for Source Data in Pivot Table.
Example: I used function =OFFSET(RAWDATA!$A$1,,,COUNTA(RAWDATA!$A:$A),COUNTA(RAWDATA!$1:$1))) to create a Name range "Source_Data".
After that, I changed Source Data in Pivot Table from current to Source_Data

[lordfa9]

hi there. i suggest you not use the whole column to reference for your PivotTable. go to your RAWDATA worksheet, and click on cell A1. press CTRL + T to convert that into a Table. press OK.

you can now create a PivotTable and your range is now dynamic. when you add data there, you can simply refresh your PivotTable and it will capture the latest data.

I don't get it, how does this help me remove the (blank)?

[lordfa9]

ok i tried out the solution and fiddled around it and I got it to disappear

Though I'm not 100% comfortable with using tables (don't really understand how they work) so I'll just leave it as is, its just aesthetic after all