topic Re: Table with Month wise data display in App Development

Table with Month wise data display

sush — Wed, 15 Jun 2022 21:43:26 GMT

Hi,

Could someone let me know if we have any table extension I can use to display data in table format month-wise?

Or if there is a way to achieve this do let me know.

Below is what I am looking for, could you let me know how can I achieve this?

I tried with Pivot but I want the data to be displayed in a table format.

Category 1

Category 2

Material

Sold To

Ship To

April

May

June

July

Aug

Forecast Quantity

Actual Quantity

Forecast vs Actual Quantity

Forecast Quantity

Actual Quantity

Forecast vs Actual Quantity

Forecast Quantity

Actual Quantity

Forecast vs Actual Quantity

Forecast Quantity

Actual Quantity

Forecast vs Actual Quantity

Forecast Quantity

Actual Quantity

Forecast vs Actual Quantity

Re: Table with Month wise data display

MarcoWedel — Wed, 15 Jun 2022 21:17:44 GMT

Can you describe how your result trying a pivot table was different from your expectation?

Re: Table with Month wise data display

sush — Wed, 15 Jun 2022 21:50:42 GMT

I want to display values for all the columns doesn't want to display them as a group. If that is achievable in Pivot I am good with it. I want to display the data similar to what is shown below.

If this is achievable in Pivot feel free to let me know how can I do this.

Category 1	Category 2	Material	Sold To	Ship To	April			May			June			July			Aug
Category 1	Category 2	Material	Sold To	Ship To	Forecast Quantity	Actual Quantity	Forecast vs Actual Quantity	Forecast Quantity	Actual Quantity	Forecast vs Actual Quantity	Forecast Quantity	Actual Quantity	Forecast vs Actual Quantity	Forecast Quantity	Actual Quantity	Forecast vs Actual Quantity	Forecast Quantity	Actual Quantity	Forecast vs Actual Quantity
Cat11	Cat21	M1	So1	Sh1	100	100	0	100	100	0	100	100	0	100	100	0	150	150	0
Cat11	Cat21	M2	So2	Sh2	150	150	0	150	150	0	200	200	0	200	200	0	100	50	50

Re: Table with Month wise data display

MarcoWedel — Thu, 16 Jun 2022 16:19:14 GMT

Is this what you're looking for?

Re: Table with Month wise data display

sush — Thu, 16 Jun 2022 16:30:14 GMT

Yes, I am able to achieve this but for Cat 1 and Cat 2 I want to display values in all the rows similar to a table.

Assume under Cat 1 and Cat 2 if the values are the same then this won't be repeated in all rows. I want to display values in all the rows. Is that possible with this?

Re: Table with Month wise data display

AjayKumar3 — Tue, 28 Nov 2023 10:45:20 GMT

yes

Re: Table with Month wise data display

vinodkumar — Tue, 31 Dec 2024 07:56:46 GMT

@MarcoWedel @AjayKumar3 @sush I've the same requirement, could you please advise is there any possibility to achieve, thanks!