% change

[#1]

hi I do have a a requirement where I need count of products if the % increase based on certain threshold limit, the issue is with underlying data.

Consider below example as you can se I have 3 dimensions Country, Rating and Product and each Country has  several ratings based on product.so my requirement is to show Count of products if it % increase on a certain threshold limit and rating.

Country	Rating	Product	Current price	Today Price	% Diff
China	A	C123	100	101	-0.99%
China	A	C456	99	102	-2.94%
China	C	C789	101	103	-1.94%
India	A	I123	96	99	-3.03%
India	B	I456	81	79	2.53%
India	B	I789	80	80	0.00%
Denmark	A	D123	121	119	1.68%
Denmark	B	D456	191	189	1.06%
Thailand	B	T789	251	249	0.80%
Thailand	C	T456	122	120	1.67%

For example I want count of products for Rating A if %increase >.5% for B >1% and for C >.25% so for Rating A and country India I need to show only 1 and for Denmark need to show 2(1 for rating A and 1 for rating B) so on...

Challenge is show I need only country and count of Products> Threshold limits not Rating column in the table without rating column.

Please help.

[antoniotiman]

Hi,

Try to add Calculated Dimension like this

=Aggr(If((Rating = 'A' and ([Current price]-[Today Price])/[Today Price] >= 0.005)
or (Rating = 'B' and ([Current price]-[Today Price])/[Today Price] >= 0.01)
or (Rating = 'C' and ([Current price]-[Today Price])/[Today Price] >= 0.0025),Country)
,Country,Rating,Product)

and Expression Count(Distinct Product)

Regards,

Antonio