LABEL Pivot table

[souadouert]

Hello,

I'm looking for a solution to not display label in the table pivot

[Frank_Hartmann]

Just paste a space sign here

hope this helps

[Anil_Babu_Samineni]

Mau be use Space instead of Name. or you want to hide Cell for label

[souadouert]

the cell for label anil

[Frank_Hartmann · Accepted solution]

then try custom format cell and adapt the label colour to the background to make it invisible:

[antoniotiman]

In Text Color

ARGB(0,0,0,0)

Regards,

Antonio

[Anil_Babu_Samineni]

That's not a good practice and there is no feature such . I didn't go that approach instead of we have good and neat. I am just assuming, those are three objects

Seems, You want to make one object instead of 3 objects why can't you make single object.

Look here Re: Pivot problem for adding another dimension

Learn from and Breadcrump seems this. Starts from Right loveisfail <-- stalwar1‌ <-- kush141087‌

[souadouert]

The problem that the three dimensions depend on the other, the region has several

Zone the Zone has several agency,

In the case where the dim is region: in the exp I elmine in the expression set lib_region

exp region:

round(sum({<LIB_ZONE, YEAR = {$(=Max(YEAR))}, MONTH, MONTHNUM = {"<= $(=MAX(MONTHNUM))"} ,SITUATION_PRODUIT,REAL_BANQUEADISTANCE.PROD_BAD={"1"}>}REAL_BANQUEADISTANCE.STOCK_NOMBRE_BAD)),

exp zone:

round(sum({< YEAR = {$(=Max(YEAR))}, MONTH, MONTHNUM = {"<= $(=MAX(MONTHNUM))"} ,SITUATION_PRODUIT,REAL_BANQUEADISTANCE.PROD_BAD={"1"}>}REAL_BANQUEADISTANCE.STOCK_NOMBRE_BAD)),

[Anil_Babu_Samineni]

Oh okay, Can you provide sample to look for some other help