Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I am facing problem in P&L reports.
I have P&L format like bold and Empty lines.
This is my report format...
| SNO | Descr | Account | Bold | Null_1 |
| 1 | Sales | 10001 | ||
| 2 | Bonus | 10002 | ||
| 3 | Fixed Fee | 10003 | ||
| 4 | Total Cost | 1 | ||
| 5 | 1 | |||
| 6 | DirectCost | 10004 | ||
| 7 | IndirectCost | 10005 | ||
| 8 | TotalDCost | 1 |
This format working fine in Straight table..
But, i want to do PIVOT table, i have 2 dimension Descr and Division.
Division i want to move up in Pivot table.
PFA,
Thanks in Advance....
Hi Sunny,
I am not able to get that format in pivot table..
See here it's missing rows 4,5 and 8.
4th column should be- Total cost= 1500+1230+350= 3080
8th column = TotalDCost= 6500+8400= 14900
These 2 rows it should be BOLD
and 5th Row Empty Row
May be this:
IF(Null_1=1,Null(),
if(SNO=4, RangeSum(Above(TOTAL column(1),1,3)),
if(SNO=8, RangeSum(Above(TOTAL column(1),1,2)),
Sum(Cost))))
Yes, My problem was if i take one more Dimension. I am not getting that format.
See here..
Report format complete changed and one more null column appearing.
How to get rid of empty column... and 4 and 8 rows BOLD.
