pcsoft.us.windevCopyright 2026, PC SOFT1 Mar 2018 07:18:00 Z27 Feb 2018 11:25:00 ZHello, I have used MS Excel's Pivot Table feature in many situations. But I am not able to understand as to how to use the Pivot Table feature of WD. What I am trying to achieve is that I have got a file which contains payment receipts from various customers. Now I want to show the data in a Pivot Table so that a user can see payment details from various view points like payments received customer wise, payment details based on products (service heads), payments between given dates, payments received in Cash/Bank/CC, etc. Is what I am thinking possible using Pivot Table as provided in WD20? TIA30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64767/read.awp1 Mar 2018 07:18:00 ZQuote Allard Hi Yogi. The dates you get for free ( Meaning day, week, fortnight. month quarter and year). If some kind …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64767/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64767/read.awp[WD20] - Can we use Pivot Table in this scenario...guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64758/read.awp1 Mar 2018 00:43:00 ZHi, what I said was from what I remebered. I looked into stuff. Ok I made the query first.. query can have parameters right .…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64758/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64758/read.awp[WD20] - Can we use Pivot Table in this scenario...guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64757/read.awp28 Feb 2018 21:20:00 ZGee, must be losing it, can't even type my own name correctly!! Regards Mikehttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64757/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64757/read.awp[WD20] - Can we use Pivot Table in this scenario...guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64756/read.awp28 Feb 2018 21:19:00 ZHi Yogi Another option that I have used successfully (also to prepare a profit report, but by job), if you have Excel 2016 (O…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64756/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64756/read.awp[WD20] - Can we use Pivot Table in this scenario...guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64755/read.awp28 Feb 2018 20:32:00 ZHi Yogi. The dates you get for free ( Meaning day, week, fortnight. month quarter and year). If some kind of date is in your fi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64755/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64733-wd20-can-use-pivot-table-this-scenario-64755/read.awp[WD20] - Can we use Pivot Table in this scenario...