Forum Discussion

PankajSoni's avatar
PankajSoni
Contributing Partner
7 months ago

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?

plant revenue & expense1.jpg

 

I want the pivot table output as shown in below screenshot. 

 

plant revenue & expense1.jpg

 

I've attached GI for reference 

 

Thanks .

1 Reply

Replies have been turned off for this discussion
  • Hello Pankaj,

     

    I have sent you a private message. Please check it.