Totals on Straight Table

[#1]

Good afternoon,

Hello

I have a straight table and I am creating totals for a particular column based upon breaks in another field.

I now have the following:

Account Number     Acct Desc       Balance           Total

1234                        Fred                1000                1200

1234                        Fred                  200                1200

1234                        Fred                                        1200

I am having an issue blanking out the total in the first 2 rows.

Thanks,

Mitch

[swuehl]

Is Total an expression, like

=Sum(Total<[Account Number]> Balance)

?

Then try

=If(Sum(Balance), '', Sum(Total<[Account Number]> Balance) )

[#3]

That ended up blanking out all the totals.

Any other thoughts?

[jepeerik]

It looks like a Pivot Table instead of a Straight table.

On the Presentation tab Add the option of Show Partial Sums on the correct Dimension and turn on option Always Fully Expanded.

[swuehl]

I think i haven't fully understood how your chart is built up.

Could you detail which dimensions and expressions you are using? Or post a small sample QVW?

[#6]

Table loaded                                          

Effective Date	AccountNumber	Name	Zip	Balance
1/31/2016	56789	Joe	11345	10000
2/29/2016	56789	Joe	11345	1300
1/31/2016	77789	Mitch	43521	4500
1/31/2016	92345	Peter	46789	12345
2/29/2016	92345	Peter	46789	11111

Using this table, I want to create a straight table that shows the following:

Effective Date	AccountNumber	Name	Zip	Balance
1/31/2016	56789	Joe	11345	10000
2/29/2016	56789	Joe	11345	1300
	56789	Joe	11345	11300
1/31/2016	77789	Mitch	43521	4500
	77789	Mitch	43521	4500
1/31/2016	92345	Peter	46789	12345
2/29/2016	92345	Peter	46789	11111
	92345	Peter	46789	23456

The total line represents a break in AccountNumber, Name ,Zip.

I am getting everything except for the total amount.

Thanks

[swuehl]

Ok, but how do you create the total line in your straight table? Still missing this piece.

Maybe just use a pivot table with partial sums instead?

[settu_periasamy]

Hi,

May be try like this in your straight table..

In the Dimension limit Tab ->  Check the "Show Total" option  for your "Effective Date" Field.

[#9]

Hi

How did you do this?

When I do it, the totals break on Effective Date instead of AccountNumber

[#10]

Thanks Settu for the handy workaround.