Hi team, is there any workaround to use LAC-W functions as dimensions in a pivot? I have duplicate values in my dataset due to differences in granularity of the joined tables in custom SQL, I want to Step-1: Remove duplicates using LAC-W function avgOver Step-2: Use percentileRank function to cat…

Hi @sssaahi , welcome to the Quick Sight Community, to address your issue of using LAC-W functions as dimensions in a pivot, you can follow these steps: Step 1: Remove Duplicates Using avgOver First, you need to remove duplicates using the avgOver function. Here’s how you can achieve this: **Create…

Hi @Xclipse , Thanks for your response. I followed these steps, but I’m getting an error in Step-3 while adding percentile bucket field in pivot rows/columns - Custom aggregation field is not allowed as a dimension PFB my data sample order, brand, region, company, revenue O1, B1, R1, C1, 1000 O…

Hi @Xclipse , I believe percentileRank is the function causing the error. Can you please help with any work-around? Thanks in advance.

Hi @sssaahi , It’s been awhile since we last heard from you, are you still in need of assistance or were you able to find a work around? If you’re still looking for further assistance, please follow Xclipse’s note to create a Quick Sight Arena so that we can look into this a bit further. If we do n…

Hi @sssaahi , Since we haven’t heard back from you, I’ll go ahead and archive this topic. However, if you have any lingering questions, feel free to create a new topic in the community and link this discussion for relevant information. Thank you!

LAC-W based calculated field in pivot

Q&A

Xclipse May 20, 2024, 11:07pm 5

Hi @sssaahi, please can you create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - Quick Sight Arena

Topic		Replies	Views
Error whilst sorting a pivot table with a lac function Q&A feature-request , quick-sight , calculations , pivot-table , Business-Intelligence-Engineer	5	293	February 13, 2024
Aggregated field not allowed in the dimension Q&A admin , quick-sight	6	83	February 14, 2025
LAC based dimensions Q&A quick-sight , calculations , Business-Intelligence-Engineer	2	106	May 14, 2024
Use Level Aware Calculations as a dimension Q&A error , quick-sight , calculations	11	1411	January 31, 2024
Calculating percent between two different LAC fields whose grouping keys are different Q&A quick-sight , calculations , Business-Intelligence-Engineer	2	327	September 26, 2023

LAC-W based calculated field in pivot

Related topics