Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is Total an expression, like
=Sum(Total<[Account Number]> Balance)
?
Then try
=If(Sum(Balance), '', Sum(Total<[Account Number]> Balance) )
That ended up blanking out all the totals.
Any other thoughts?
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.
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?
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
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?
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.
Hi
How did you do this?
When I do it, the totals break on Effective Date instead of AccountNumber
Thanks Settu for the handy workaround.