Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
make a chart with 3 expressions
'Product'
FirstSortedValue(Product, -Sales)
max(Sales)
Products:
LOAD * INLINE [
Product, Sales
a, 10
b, 20
c, 20
d, 50
e, 20
f, 10
g, 10
h, 200
i, 300
j, 100
k, 150
];
NOCONCATENATE
Pro:
LOAD Product,
Sales
RESIDENT Products
ORDER BY Sales DESC;
LET vMaxProduct = Peek('Product', 0, 'Pro');
LET vMaxSales = Peek('Sales', 0, 'Pro');
DROP Tables Products;