How to hide a row in a pivot table?

Hello. I am looking to hide (not filter out) a row based on its content in a pivot table widget. I haven't been able to find a native functionality for that, but I assume there's javascript to do that. Can anyone assist? I've only been able to find column masking, but that isn't helpful.

newbie12

Posted 1 year ago·Last reply 8 months ago

6 comments

naga

·8 months ago · Edited

Hi DRay, was this resolved. I do have similar kind of requirement. Want to use a column for sorting in columns category of a pivot widget but hide it from display. Attached screenshot. Row with values 1 2 3 4 5... should be hidden.

jpacheco

·1 year ago

newbie12 Did DRay s above comment help? If so, do you mind marking it as a solution? If it did not, please let us know so we can take future action on finding you a solution. :) Thanks for being a part. of our community!

newbie12

OP1 year ago

No.

DRay

·1 year ago

Hi newbie12,

Thank you for reaching out.

Can you take a look at this post and let me know if it helps? It's specifically written for columns, but with some customization it should work for rows also. https://community.sisense.com/discussions/build_analytics/pivot-2-0---hiding-columns-from-the-display/3607

newbie12

OP1 year ago

No, this doesn't help. I don't know enough javascript to edit this from column to row.

DRay

·1 year ago

Hi newbie12,

Roger that. I have reached out to your account team to get a technical resource to work with you.