4 Replies Latest reply on Aug 24, 2016 4:10 PM by Dan Cory

# Table Calulation with lookup filter to get % of total

**** Dan/BoraBeran

You had helped me before regarding LOD calculation resulting product joins.

You assistance helped to decide on extract rather than using live connection, when LOD's are there.

If you can help me again it will be really great.

Now, My problem is different.

I am working on a tableau calculation. Not able to get the total for the( Highsales+Lowsales)  on a year basis

I cannot use LOD calculations because of special requirement constraints.

I want the bottom row to be be total of first row for each year (98+38) and (68+133).

Now I am getting wrongly as 337(i.e sum of both years), I want total for each year.

i.e. 2nd row should look like,

136 136 201 201

If I get this correctly then only I can get to % of total for respective years and after that, calculate the difference in % of Total between the years.

Thanks

Anu

• ###### 1. Re: Table Calulation with lookup filter to get % of total

Hi Anu,

The closest analog of a FIXED LOD dimension field

(in the Pre-LOD era of 8.x) is a Conditional Set.

Your [Sales Decider] logic is used to build a Condition.

And the VizLOD granularity of Product ID / City / Year

is used as the Set member Dimensions (via concatenation).

The resulting Set allows to avoid the [Sales Decider]

Discrete Aggregate's Ignore in Table Calculations trap.

Yours,

Yuri

• ###### 2. Re: Table Calulation with lookup filter to get % of total

Hi Yuril

Thanks for your help..I cannot find the attached.Could you please attach again.

Once again, Big Thanks

• ###### 3. Re: Table Calulation with lookup filter to get % of total

Hi Anu,

as a link with a Clip icon (at the lower left).

Yours,

Yuri

• ###### 4. Re: Table Calulation with lookup filter to get % of total

Thanks Yuri! Awesome solution.

Dan