you are not so clear in your question and where is the problem?
i have lot of experience in finance reports, and i can tell you that you are in the right way of
using excel files to set the grouping and the view definitions.
but, the end date should be in a 1 qlikt able thay have all the column and fields you need for the report.
also you should use a straight table and not a pivot!!
the problem of straight table is that it doesn't sort good if you use expression sort, so use a hidden dimention to sort.
Thank you for your reply.
I am going to try to be more clear on my question:
I have managed to create a descent looking P&L report by mapping accounts with the excel file.
For people to see the P&L report for their cost centre, they had to click on their cost centre from a list box.
We are a afiliate of a bigger group and the group are not using the same format as us. In order for us to adjust to their format, I would like to instead of clicking on a cost centre, show for example overheads for Finance, Marketing, Sales beneath each other.
For this model people will not be able to click on a cost centre from a list box but will only see one P&L report for the whole company. It must look like the excel file "Must look like this.xls".
I think this would envolve adding the cost centre groups to the mapping file aswell and maybe using set analysis, but I am not sure on how to do this.
Please let me know if you need more info.