CODEWITHSUNDEEP
tableau-api
Ally Kat
Ally Kat

Reputation: 211

how do I subtotal Calculated measure by Year Date dimension in tableau

I am trying to subtotal my years. When I do so the subtotal is a crazy #.

test = [MT]/[FA]

Formula for Cells = ((SUM([test]))*12)*(SUM([FA]) / TOTAL(SUM([FA])))

Formula is calculating using pane downenter image description here

Upvotes: 0

Views: 526

Answers (1)

minatverma
minatverma

Reputation: 1099

Replace your test calculation as :

SUM( [MT] )/SUM( [Faccounts] )

Your window calculation will error out.

Materialise your main calculation as below :

(([test])*12)*(SUM([Faccounts]) / TOTAL(SUM([Faccounts])))

You will get correct result . Somehow I am unable to upload the workbook .

Upvotes: 1

Related Questions