PankajSoni
2 years agoContributing Partner
Generic inquiry pivot table help to show revenue & expense
Hi,
I've created a below generic inquiry, and I would like to setup a pivot table using the concatenation formula.
To illustrate, if you examine the screenshot provided, you'll notice that "VLDD80" represents the product code, and there's a corresponding project ID configured in the setup.
My objective is to establish a new pivot table that relies on a combination of both the product code and project ID. how can i achieve this?
I want the pivot table output as shown in below screenshot.
I've attached GI for reference
Thanks .