Hi,
I want to add calculation at last in pivot table.
Attaching the screen shot for your reference which highlighted in red.
I want to do calculations by comparing the cells in the table is that possible?
Hi,
One quick solution that can help you to achieve it is:
(1) You can create “week over week sales” calculated field as
wowSalesChange=periodOverPeriodDifference(sum(sales), {order_date}, WEEK, 1)
(2) Duplicate your pivot table visual of weekly sales. Replace sales value in measure for pivot table of this duplicate visual with WoWSalesChange
(3) Use freeform layout overlay visual to overlap both visuals as depicted in my image example below.
Realized you are using Pecrentage Difference so calculated field formula will change:
WoWPercentageDiff=periodOverPeriodPercentDifference(sum(sales),{order_date},WEEK,1)
In my pivot table I used issue URL for the count but in above formula sum() need number format but in my case which is string format. Is there any way to to convert the string into int.
Same formula will work for string datatype, you can simply change sum() to count() in formula e.g. for String type “order_id” field you can use calculated field.
In datatype it is possible to convert String to number if you to use sum().
PoPOrderCountPercent= periodOverPeriodPercentDifference(count({order_id}),{order_date},WEEK,1)
Thanks your formula is working but I don’t know to overlap the visuals. I have clicked the freeform layout but i don’t know how to overlap.
Pls send me if u have any reference video
Hi @AnwarAli ,
Please help me on this.
Please refer to example of free form visuals in demo central. There are several dashboards build using free form. You can also edit (analysis mode) by click on pencil icon from left pane and get inspiration how some of free form visuals are build.
https://democentral.learnquicksight.online/#Dashboard-FeatureDemo-Free-form-RSU-Tax-Report
https://democentral.learnquicksight.online/#Dashboard-FeatureDemo-Reporting-Financial-Statements
Thanks a lot for this resource