Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Akina0929
Creator
Creator

added value to the field in script level not getting in pivot table?

Hi,

  I have added value to the field in script after loading, that value I am getting in list box , same dimension I am using in pivot table but that value not getting in that, please help me how to get.

Best Regards

Anji

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

May be the expression you have written do not have value for that dimension.

You can try below things.

1. Go to Dimension Tab and click on the dimension and uncheck "Supress When Value is Null".

2. Go to Presentation Tab and uncheck "Supress Zero Values"

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

4 Replies
Anil_Babu_Samineni

Question not clear to me

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

May be the expression you have written do not have value for that dimension.

You can try below things.

1. Go to Dimension Tab and click on the dimension and uncheck "Supress When Value is Null".

2. Go to Presentation Tab and uncheck "Supress Zero Values"

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jmvilaplanap
Specialist
Specialist

Hi

Maybe you have null values, to check it you can create a straight table with all the columns of the table and check this column specifically to see if there is null values.

Regards

Akina0929
Creator
Creator
Author

Thank you koushik