Hi, I’m new to quicksight and trying to figure out how to calculate period over period data. For now my challenge is showing both calculated field “WoW Revenue Diff” while selecting field"execution_week". If I remove execution_week field, the calculated field “WoW Rev Diff” can be shown. The calculated field is using “periodOverPeriodDifference(sum({order_revenue}),{execution_day},WEEK,1)”. Any suggestions?
Here’s how it looked without selecting execution_week. The numbers look right, but I do need to show the week column tho…
Hi @jingwenm, welcome to the Quick Sight community. Try using the hide functionality. Also, try using the Amazon Q Assistant on the function documentation page.
Showing and hiding pivot table columns in Amazon QuickSight - Amazon QuickSight)
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community!