Hello! I want to calculate the percentage of parent row in Pivot Table. In Excel I can easily calculate with “Value Field” and in Power BI with “ISINSCOPE” function. [Captura de tela 2023-11-29 172857]

Hi @rafael.oda you could try to calculate it with Lag - Amazon QuickSight The lag function calculates the lag (previous) value for a measure based on specified partitions and sorts. BR

Hey @ErikG , thanks for the reply. Here an example of my dataset and the final result that I want. [image] I couldn’t understand how to calculate this with “Lag”

Hi @rafael.oda is it still an issue? After some thought i would say you have to use some workarounds. As you are using a pivot table and i dont know how to use different calculation on different levels. I built something with 3 different fields. [grafik] BR

hi @rafael.oda , We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question. please let us know. kind regards, Wakana

How to calculate % of Parent Row Total

Q&A

Koushik_Muthanna November 30, 2023, 10:44am 4

@rafael.oda ,

If you have sample data, use the arena ( NEW -- QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community ) , helps others in answering questions

Topic		Replies	Views
Calculating percentage difference across rows Q&A analysis , quick-sight , calculations	1	212	June 28, 2023
Percent of Total Calculation Q&A quick-sight , calculations , pivot-table , Business-Intelligence-Engineer	6	154	February 28, 2025
Percent for Pivot Table Q&A quick-sight , calculations , pivot-table , Business-Intelligence-Engineer	4	89	December 11, 2024
With a pivot table of values, want to add a single % column Q&A quick-sight , calculations	3	2287	July 25, 2022
Calculating Row Percentages with Aggregation Q&A quick-sight , calculations , pivot-table , Business-Intelligence-Engineer	4	474	December 19, 2023

How to calculate % of Parent Row Total

Related topics