Compare Data

[qvdrago]

Hi all,

Please  i need help !!!

I would like compare value with set analisys 

SUM( {$ <Value-= {0}> } Value * Quantity / Currency)

The user select the "comparison season"  B21

and I would like Compare alla season with selected compare season

and show the result like this

Season	Value	Compare  Filter Selection "B21'	%
Totali	6.409,30	2.817,70	56%
B20	398,85	2.817,70	-606%
B21	2.817,70	2.817,70	0%
B22	2.709,75	2.817,70	-4%
B23	483,00	2.817,70	-483%

Many Thans

[agigliotti]

Hi @qvdrago ,

For the % column you can use:

SUM( {1} Value) / SUM(TOTAL Value) - 1

for the Value column you can use:

SUM( {1} Value)

I hope it can helps.

Best Regards

[qvdrago]

Thank you for your replay

If  I  use {1} and total not include other selections like customer, article , product type etc

I would like compare 2 season  B23  vs b21    B22 VS B21  etc 

Regards

[agigliotti]

Right, if you want to ignore only Season field selections you can use:

{<Season>}  instead of {1}

BR