Application of a formula on vales of different codes are not appeared against each code

[nevilledhamsiri]

Hi, Community

Please look in to my calculation which was done on separate codes by application of a formula in the P/T. The formula used to multiply is  there in the straight table. The issue is once applied, correct amount is shown on the total row but I need the same amounts to be shown against the each code.

Please help

Neville

[dplr-rn]

only() should be used if its an expression.

if its a calculated dimension just use ACCOUNT_CODE+1

[nevilledhamsiri]

Thanks a lot Ranjith

For the 2nd issue, I am still struggling. Just check whether what you propose does work?

Neville

[dplr-rn]

it works for me. See below. top table is the rail code as expression. second one is as calculated dimension

[nevilledhamsiri]

Could you please type & send me the complete formula(calculated dimension). As you show, it is what I need. Please write it in full

[dplr-rn]

have attached the qvw in previous reply

[nevilledhamsiri]

I got it, I had done an error in haste, Sorry dear, Thanks a lot for your time. You simply did it well.Look forward to same response in future

Rgds

Neville

[dplr-rn]

no problems. shit happens when in haste

[nevilledhamsiri]

Dear Ranjith,

Please understand that I have made an set expression something like below & create a pivot table such as one below. If I need to bring in the relevant code to appear in the next column, what expression to be written?. Can the same set expression be used with account_code instead DR-CR at the end

SUM({<ACCOUNT_CODE={'77150','78450','77451','78451']>}DR-CR)

77150  500

78450  1000

77451  1500

78451  2000

[nevilledhamsiri]

here DR-CR being the measure right

[dplr-rn]

No 100% clear what you mean. but in general if you want to show a dimension field but with set analysis use Only function like i mentioned for the Rail_Code . But only function should be used with caution as it returns empty if more than 1 option exists. check help site

Can you show me desired output?