Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator II
Creator II

Issue in Pivot table

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...

SNODescrAccountBoldNull_1
1Sales10001
2Bonus10002
3Fixed Fee10003
4Total Cost1
51
6DirectCost10004
7IndirectCost10005
8TotalDCost1

This format working fine in Straight table..

Capture.JPG

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....

7 Replies
sunny_talwar

What exactly is the issue you are facing Paul?

paulwalker
Creator II
Creator II
Author

Hi Sunny,

I am not able to get that format in pivot table..

Capture.JPG

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

sunny_talwar

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))))


Capture.PNG

paulwalker
Creator II
Creator II
Author

Yes, My problem was if i take one more Dimension. I am not getting that format.

See here..

Capture.JPG

Report format complete changed and one more null column appearing.

How to get rid of empty column... and 4 and 8 rows BOLD.

paulwalker
Creator II
Creator II
Author

If anyone have Idea... Please let me know..

Clever_Anjos
Employee
Employee

This?

Capturar.PNG

Clever_Anjos
Employee
Employee

PFA