Showing comparison on Pie Chart with using radius

[nekia]

I'd like to know how to create the following chart which is introduced in Pie chart | Qlik Sense on Windows Help . Could you please give me the details of chart function which used for calculating radius?

Sales by product sub group in a pie chart with radius measure containing a comparison of sales from the previous year

To show the following sales of 2023/3/2 in a Pie Chart with a radiu measure containing comparison of sales from 2023/2/2:

Load * inline

[

date, product, sales

2023/3/2, productA, 100
2023/3/2, productB, 120
2023/3/2, productC, 110
2023/3/2, productD, 50
2023/3/2, productE, 70
2023/2/2, productA, 130
2023/2/2, productB, 180
2023/2/2, productC, 100
2023/2/2, productD, 50
2023/2/2, productE, 80

];

Thanks

[Lisa_P]

Based on your data, I have created this chart:

Dimension: product

Measure for Angle: Sum(sales)

Measure for Radius: Sum({<date={'2023/3/2'}>}sales) - Sum({<date={'2023/2/2'}>}sales)

 or you could use dynamic like: 

Sum({<date={'$(=Date(Max(date)))'}>}sales) - Sum({<date={'$(=AddMonths(Date(Max(date)),-1))'}>}sales) 

The other trick is that you must select Donut under Presentation to get the radius

[nekia · Accepted solution]

It perfectly worked in the actual data of my environment! Thank you so much for prompt support.