Hi all, I wanted to know if there is a possibility to hide rows in a pivot table. It would be useful to me as I would like to keep the same percentage values calculated on the total but display only certain case histories.
Thanks in advance to anyone who will answer
Hi @marengog and welcome to the QuickSight community!
To hide specific rows, you can setup filters on your visual as seen below.
Then, to keep the same percentage values, you’ll want to create a calculated field that uses ‘PRE_FILTER’. I would suggest checking out this article for more information around building calculated fields for this type of instance.
Let me know if you have any additional questions
Hi @Brett thank you very much for the advice I did not know this possibility. The thing is that I apply two filters, the first one with two date controls and then excluding the null values (they are the result of an ifelse). By using pre_filter I also lose the first date filter which I want to keep instead
Hi @marengog,
Could you explain a little more about your scenario and possibly include a screenshot of your visual so that I can see the whole situation?
What are the filters you’re currently using?
To get around the PRE FILTER, you could potentially use an ifelse statement as well.
Hi, I have a database that contains raw data that I put into a pivot table to organize them. Specifically I have this hierarchy
Non PCP
Non PCP CN out
I would like to view only Non PCP CN out with the percentage calculated based on Non PCP.
e.g. Non PCP 100 units
Non PCP CN out 60 units
i want to see just 60%
As you can see from the image I would like to keep the same percentages but without seeing the first line (Non-PCP)
Hi @marengog,
What if you tried something like the following:
ifelse(
{category} = ‘Non PCP CN out’,
sum({units}) / windowSum(sum({units}), , PRE_AGG),
null
)
Let me know if this works for your case
Hi @marengog,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @marengog,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!