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.
