Dear QV Experts,
Based on my previous thread, i tried in the calculated dimension,
=If(Aggr(Rank(RangeSum(Sum(Sales), Sum({<CustomerName = e(CustomerName), Year>} 0))) <= vTopX, CustomerName), CustomerName)
My current year is 2014, The customers listed below doesnt have sales in the year 2014 but have in the 2013 of 88 dollars.
But in the enclosed screenshot, For the customers i am getting only null. Can you please suggest me on this.
| Sum When 2014 & 2015 Sales is Null | | | 2013 |
| Turner Supermarkets | - | - | 33 |
| Lee Supermarkets | - | - | 23 |
| Roach Wholesale Club | - | - | 7 |
| Moses Retail Store | - | - | 6 |
| Hardin Supermarkets | - | - | 5 |
| Kent Pharmacy | - | - | 3 |
| Maddox Wholesale Club | - | - | 3 |
| Chang Wholesale Club | - | - | 2 |
| Knapp Supermarkets | - | - | 2 |
| Frazier Wholesale Club | - | - | 1 |
| Duran Pharmacy | - | - | 1 |
| Lowery Supermarkets | - | - | 1 |
| Rivas Grocery Stores | - | - | 1 |
| Pennington Wholesale Club | - | - | 1 |
| Sharp Wholesale Club | - | - | 0 |
| Cochran Wholesale Club | - | - | 0 |
| | | 89 |
NOTE: Though it is customer dashboard, cant able to share the qvw.
Thanks in Advance.
Sasi
