Klark Ooi wrote:
Hi,
Am I able to use datapilot to build summary table rather than
values/statistics? For eg, I have a long list of table with:
Country > Customer Name > contact person > contact info
My sample wish list will be in this form:
===============================================
SG Company_A Person_A 1234
Person_B 2345
Person_C 7663
Company_ABC person1 346387
Person2
VN Company_HH Person3 4545
===============================================
As you can see, there is no consolidation of numbers, but data fields.
Hope you understand my question. Thanks.
Warmest regards,
Klark
Yes, the pilot can aggregate text values, showing all existing
combinations in row fields and/or column fields. The only data field
function that works is "Count" then, counting the occurrence of the
respective combination of text values.
A most simple pilot with all fields as row fields lists all existing
combinations of the involved fields.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
