Pivot Table expression/Dimension

[MauriceLudo]

Hi,

I would like to know how I can present in a PivotTable three expression for each expression a single dimension.

thank you for you

C-Attached Screenshots

[balar025]

What are your dimensions and expressions?

You can use pivoting by dragging dimensions horizontally.

[MauriceLudo]

Thank you for your reply

'Dimension : Num_Week_Cloture'

'expression traitement with Num_Week_Cloture'

'count( {<[File d’attente]={'N1-Developpement'}, Statut={'Annulée','Terminé'}>} N°Ligne_Nb)'

'Dimension : Num_Week_Création'

'expression Flux with Num_Week_Création'

'count( {<[File d’attente]={'N1-Developpement'}>} N°Ligne_Nb)'

look Attached App

[balar025]

Still it is not clear.

In your example, i can see there is serial key dimension with there different expression and calculation is different for each serial key(Creation/Cloture) and expression except Stock.

What is your final output you needed?

Regards,

Ravi Balar

[balar025]

Is it your expected output?

Num_Semaine	1			2			3			4			5			6			7			8			9			10			11			12			13			14			15			16			17			18			19			20			21			22			23			24			25			26			27			28			29			30			31			32			33			34			35			36			37			38			39			40			41			42			43			44			45			46			47			48			49			50			51			52
	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock	Flux	Traitement	Stock
	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76	1	0	76	17	4	76	12	14	76	29	21	76	24	14	76	24	5	76	30	16	76	30	22	76	21	13	76	21	18	76	10	17	76	25	18	76	16	22	76	16	38	76	19	27	76	11	13	76	25	26	76	26	29	76	26	47	76	20	20	76	24	27	76	28	28	76	21	16	76	13	9	76	13	21	76	19	23	76	14	8	76	8	8	76	20	18	76	20	22	76	17	21	76	8	19	76	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76	0	0	76

[MauriceLudo]

Thnak you Balar,

yes exactly for processing and flow, on the contrary stock it is false, the rule to calculate stock it is, also presentation like the scrennshort top

[MauriceLudo]

Stock :   S1 = F-T

                 S2 = stock S1 + F-T

                 S3 = Stock S2 + F-T