Script Measur

[Manni_SM]

Hi @rubenmarin  i have measure calculated  in script 

sum(cash)   as  cash

now i want to use direct cash field in pivot table  .  its giving me null values.

i tried using

max(cash)

first(Cash)

sum(Cash)

count(cash)

nothing worked any other alternate for this? 

[rubenmarin]

Hi, the null values could be caused by something in the data model, by the relations between 'cash' and the dimensions.

You can try a copy of the pivot table and transform to simple adding cash as dimension, and confirm that all (or at least some of the rows) have data in all dimensions.

[Manni_SM]

Hi @rubenmarin  yes i have values 

[rubenmarin]

I can olnly see a dimension there (besides the cash), if it's a pivot I think there would be at least one additional dimension.

Also keep the measure Sum(cash) to confirm if it sums by row and in the totals or not.

[vighnesh_gawad]

in pivot table, which dimensions and measures you are using? 

[Manni_SM]

Hi @VIG ,

Dim:  Month:   Feb  

year : 2026

Application :  HDD

Measure: 

Cash1 

Cash2 

Cash3 

Cash 3

Cash 4

Total  ( cash1+cash2+cash3+cash4)

ctr   ( count of ctr)

----------------

Note:  Cash 1 to cash 4 are direct measures calculated in script 

total is   sum of cash 1 to cash 4

ctr   is  count of ctr