Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Best practice building P&L? Examples?

Hi there!

  1. I´m trying to find out good ways to build different P&L (pivot tables) with drilling/connection to transactional data from those tables for a companies finance departments. I have built in codes for sums (P&L-lines) etc in the data warehouse to get the correct order for the P&L. This works, but are there other ways to do this? Best practice?
  2. Is there any possibility to format different levels of subtotals with different formats in a pivot table? How?
  3. Most qvw-examples form QlikView are about sales, production etc or very high level of finance without drills to low level P&L analysis or transaction data to general ledger. Does somebody have an qvw-example of P&L down to low level? (i e account level) with pivot table and/or with connection to transactions to general ledger.

Thanx,

Tobias

2 Replies
Not applicable
Author

Tobias:

This post was a while back...did you find anything?  I'm basically looking for the same thing.

Not applicable
Author