How to Hide a Repeating Dimension Row

[#1]

Hi All,

I want a Distinct Row within the Field, and im struggling to get it right, please help

e.g

Field A	Values
0001	100
0001	250

output:

Field A	Header 2
0001	350

Thanks.

[sunny_talwar]

In the straight table object you can use Field A as your dimension and Sum(Values) as your expression.

[lironbaram]

create a straight table chart

use field A as dimension and create an expression sum(Values)

[sunny_talwar]

For script you can do this:

Table:

LOAD * Inline [

[Field A], Values

0001, 100

0001, 250

];

Join(Table)

LOAD [Field A],

          Sum(Values) as TotalValues

Resident Table

Group By [Field A];

Create a table box with [Field A] and TotalValues to get the result you are looking for.

HTH

Best,

Sunny

[#5]

Hi All,

your answers are correct, but if i want to hide a repeating Dimension as condition?

how do i do that?

[phaneendra_kunc]

First image is straight table chart output? or a table box?

If it is table box use a chart with FieldA as dimension and sum(Values) as expression and that will aggregate the result.

If it is a straight table and you still see two rows, one thing might be to do with the length/spaces in your Field A. use "trim([Field A]) while loading the script.