what is going on here? my table is calculating total for rows very badly, without filters applied, this is an error because I am working with spice? I don’t want to have to check all my analysis for an error that I had overlooked until now, but it is serious.
Hi @Juan,
What aggregation are you using? Are you doing a count of company_id? My guess is that you have some company_ids that are in multiple rows, so the total count is less than the sum of the individual counts.
1 Like
@David_Wong no aggregation, I have a count distinct of company_id in the values field, and then being a pivot table, I show the total by rows. these fields are not calculated, nor the table has filters, that’s why the error hit me and I don’t know what it’s due to.
Hello @Juan, were you able to resolve the problem you were facing with the total values in your pivot table? If so do you mind posting the steps you took to fix it? Otherwise, if it is a continuing issue please post a new topic in the community so you can be at the top of the priority list for a response from one of our Quick Sight experts. Feel free to link to this topic as well to provide relevant information for the next expert to best assist you. Thank you!
Hello @Juan - Since we have not received a response from you
on this question, we are going to archive the question. If you still need this question answered,
please create a new question topic.