Hi, how can we get the pivot table to show the first value of the week when collapsing the column date , and show the actual sum value of the day when expanded? Currently it summed up all of the value of all days of the week.
so in the case of the snip below, i want 2,034 shown on the first row when i collapsed the column into week.
Hi @jesstnto,
However you have the aggregation set for your value, will be how it acts when you collapse the table as well. So to get the max, you would need to change your values’ aggregation to ‘Max’:
If you only have one value per day using the max won’t matter when expanding, but it will not be able to show sum when expanded and Max when collapsed.
Let me know if you have any additional questions.
The problem is, i don’t want to have the min value of the week, but i want to get the value of the first date of the week.
If you take a look from the picture i attached, take an example of the last row. When i collapse the date to week, i want 1,961 to be shown (because that’s the value of the 2nd Jan , which is the first date of the week). but if i use aggregate - min as you suggested, i would end up with 1,507.
Hi @jesstnto,
After some testing, I do not believe that condensing sections and recognizing the ‘earliest’ value is a currently available option. Additional pivot table sorting options would be very helpful so I’ll mark this as a feature request to promote visibility to the support team.
Thank you
Hi @jesstnto,
While I’ve marked this as a feature request already, following up to see if you had any additional questions?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @jesstnto,
Since we have not heard back any further, I’ll go ahead and close out this topic. You can keep an eye out on features being implemented through the ‘What’s New’ section of the community. If you have any additional questions, feel free to create a new post in the community.
Thank you!
