Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey All
Need to make a combination expression :
Following expression is working
=count({<Date={">=$(vStartDate)<=$(vEndDate)"}>}SALES)
Date UNLOAD_TO_DIRECTIVE EDI
13/01/2014 EDI EDI
13/01/2014 KLBIKK KLBIKK
14/01/2014 BLE014 BLE014
14/01/2014 EDI + 20 EDI + 20
Need the following overview - total of all directive and total of all EDI*
Date UNLOAD_TO_DIRECTIVE EDI
Total 4 2
13/01/2014 2 1
14/01/2014 2 1
Can some help me out plse
Tks
Rudi
Hi,
Create a Straight table and try like this
Dimension : Date
Expression 1 - Total of all Directive:
=count({<Date={">=$(vStartDate)<=$(vEndDate)"}>}SALES)
Expression 2 - Total of all EDI:
=count({<Date={">=$(vStartDate)<=$(vEndDate)"}, UNLOAD_TO_DIRECTIVE={'*EDI*'}>}SALES)
Now select Sum of Expressions option in
Chart Properties -> Expression tab.
Regards,
Jagan.
can you briefly explain how below coming?
Date UNLOAD_TO_DIRECTIVE EDI
Total 4 2
13/01/2014 2 1
14/01/2014 2 1
UNLOAD_TO_DIRECTIVE = COUNT OF ALL ITEMS UNDER UNLOAD_TO_DIRECTIVE IN THIS CASE 4
EDI = COUNT OF EDI AND EDI* IN THIS CASE 2
Hi,
Create a Straight table and try like this
Dimension : Date
Expression 1 - Total of all Directive:
=count({<Date={">=$(vStartDate)<=$(vEndDate)"}>}SALES)
Expression 2 - Total of all EDI:
=count({<Date={">=$(vStartDate)<=$(vEndDate)"}, UNLOAD_TO_DIRECTIVE={'*EDI*'}>}SALES)
Now select Sum of Expressions option in
Chart Properties -> Expression tab.
Regards,
Jagan.
See attachment.