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.
Hi @rafael.oda
you could try to calculate it with
BR
1 Like
Hey @ErikG, thanks for the reply.
Here an example of my dataset and the final result that I want.
I couldn’t understand how to calculate this with “Lag”
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 
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.
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