A few values in my pivot table disappear upon collapsing the pivot table

Question & Answer
, , ,
1

Hi Team,

In my pivot chart visual, I see some values hidden upon collapsing a few fields. They only appear when I expand to the smallest grain. How can I ensure all values are displayed even when I collapse the chart?

image
image1344×298 14.1 KB

The values all appear when expanded to the smallest grain.

Adding calculations here for reference:
PV Titles - Availed CS PoP:
{PV Titles - Availed}-lag({PV Titles - Availed},[{Period End} ASC],1,[{Country Code}, Tier, Vendor, {Lead Locale},{Studio Deal Status}])

GVWC Cover - PV Availed - CS PoP:
{GVWC Cover - PV Availed}-lag({GVWC Cover - PV Availed},[{Period End} ASC],1,[{Country Code}, Tier, Vendor, {Lead Locale}, {Studio Deal Status}])

I don’t see this issue with other pivot tables upon expanding/collapsing values and I believe has something to do with me using lag functions. Any help is appreciated here!!

Thanks,
Tanisha

2

Hello,

Do you have any pivot tables that work correctly with lag functions? I do not find any mentions that this is supported on our documentation.

3

Hi @andres007,

Yes, part of my pivot table- with %age values. The values towards the right in the screenshot I initially shared works perfectly with lag functions even when collapsed.

GVWC Cover - PV Availed - CS PoP:
{GVWC Cover - PV Availed}-lag({GVWC Cover - PV Availed},[{Period End} ASC],1,[{Country Code}, Tier, Vendor, {Lead Locale}, {Studio Deal Status}])

Thanks,
Tanisha

4

Hi @Tanisha_Shetty,
I am going to archive this topic since it has been open for an extended period of time. If you would still like assistance with this, or if you have a new QuickSight question, feel free to post a new topic in the community so you will be at the top of the priority list for a response from one of our QuickSight experts. Thank you!