Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi team, i have a doubt .
customer name sales sales
abc 2000 25000
xyz 3000 4000
lmn 2500 5000
i want sum of sales when customer abc or ayz
sum({<[customer name] = {'abc','ayz'}>}sales)
If you mean xyz instead of ayz, then replace ayz with xyz in the expression above.
Use below in script
===============
CrossTable(Year, Sales)
Load * Inline
[
customer name, YEAR1 sales, YEAR2 sales
abc, 2000, 25000
xyz, 3000, 4000
lmn, 5000, 6000
];
=====================
Use below in text box (Same as suggested by Stefan)
=SUM({<[customer name] = {'abc','xyz'}>}Sales)
Simply write
Sum({< [customer name] = {'abc','xyz'} >} sales)
but your question is for customer abc or ayz
replace ayz to xyz in the table.
HI IF I USE AND CONDITION INCASE OF OR CONDITION ITS SHOWING NO VALUE
Then write like below script because you want only abc, xyz then ignore lmn
Sum({< [customer name] -= {'lmn'} >} sales)