3 Replies Latest reply on Jul 26, 2016 2:48 PM by Shinichiro Murakami

# Nested Table Calculation Help - Difference From (QoQ) on a Percent of Total

Hi, hope someone can help with this.  I am trying to do a nested table calculation and it's not working quite the way I am expecting.  I am trying to determine the difference between quarters of particular grades by Percent of Total (Table Down).  Here is what I have so far.  The row in orange is the row I am trying to achieve, but can't.  Any help you can provide would be greatly appreciated!

R

GroupCategoryQ2Q3
A-E

Difference between Qtrs

Difference between Qtrs

32

17.2%

33

1

17.4%

.2%

F

Difference between Qtrs

Difference between Qtrs

44

23.7%

48

4

25.3%

1.6%

G-H

Difference between Qtrs

Difference between Qtrs

57

30.6%

58

1

30.5%

(0.1%)

I-J

Difference between Qtrs

Difference between Qtrs

37

19.9%

36

(1)

18.9%

(1.0%)

K-L

Difference between Qtrs

Difference between Qtrs

13

7.0%

12

(1)

6.3%

(0.7%)

M

Difference between Qtrs

Difference between Qtrs

3

1.6%

3

0

1.6%

0.0%

• ###### 1. Re: Nested Table Calculation Help - Difference From (QoQ) on a Percent of Total

This is multiple lavel of Table Calculation which you can solve by adding calculated field with LOD.

lod

Overview: Level of Detail Expressions

[Percentage of Quarter]

To align table frame appropriately (if there are null, it's missing the row),

You 'd better change the table structure a little bit as below.

Then you can hide the header.

Thanks,

Shin

9.1 attached.

• ###### 2. Re: Nested Table Calculation Help - Difference From (QoQ) on a Percent of Total

Thank you so much Shinichiro, this works for me and makes it easier!

• ###### 3. Re: Nested Table Calculation Help - Difference From (QoQ) on a Percent of Total

Sounds good.

Shin