Removing Blanks from Pivot Row Subsets

Hello @sudhanss, welcome to the Quick Sight community!

Would you be able to create a demo version of the issue you are experiencing in Quick Sight Arena? I’ll include some documentation on how to build an Arena dashboard:

This will allow me to see the problem you are having and test out some possible solutions in Quick Sight directly. Just make sure that you remove any sensitive data since this is a public forum.

Alternatively, can you post some screenshots of the visual issue, plus explain what the expected outcome is and any calculated fields you may be utilizing. That would allow me to provide a more detailed response to your question. Thank you!