Pivot Table - Sum specific lines

[vinicius_siquei]

Folks,

I have the Pivot table below in my application.

As you can see, the line 5 and some others are not being displayed.

It happens, because line 5 is the sum of records from line 3 and 4.

Could anyone help me ?

I did this expression using Set Analysis, however the result was not displayed separated by month as it should be.

I also attached my application, in case anyone prefer.

Thanks,

Vinicius

[whiteline]

Hi.

Consider to change the data structure for such requirements.

For example, you can create another field [Report Linha] and connect it with Linha field like this:

[Report Linha],  Linha

01,     01

02,     02

03,     03

04,     04

05,     03

05,     04

...

Then you can use Report Linha as dimension and build the report using just Sum() expression.

Anyway, it's hard to do it with set analysis within the current data model as there is no relation between [Linha]=05 and any [Mes] value. You can see it if you create table box with these two fields.

[preminqlik · Accepted solution]

Hi there,

find attachment

[vinicius_siquei]

Thanks for your answer. Very insightful.

[vinicius_siquei]

Thanks Kumar!