Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day,
Situation:
I have a dimension called 'Category', This dimensen is structured trough an Excel file.
For example;
Accountnumber Category
700003 OMZET
700103 OMZET
720003 FIN
720003 FIN
And so on, so if I put Category as a dimension in a pivot table, there is no problem at all.
But I want to do calculations based on the typ of category.
For example:
OMZET - FIN
And display this in the same table.
The calculation for all categories is :
if(sum(GLE15_CR) > sum(GLE15_DB), sum(GLE15_CR) - sum(GLE15_DB)) &' '& if(sum(GLE15_DB) > sum(GLE15_CR), sum(GLE15_DB) -sum(GLE15_CR))
Now how do I do This so that every category is a seperate Line in a P&L pivot and I can do the calcualtions depending on if statements lik:
if(Category = 'OMZET', sum(GLE15_CR) > sum(GLE15_DB), sum(GLE15_CR) - sum(GLE15_DB)) &' '& if(Category = 'OMZET',sum(GLE15_DB) > sum(GLE15_CR), sum(GLE15_DB) -sum(GLE15_CR))
/
if(Category = 'FIN', sum(GLE15_CR) > sum(GLE15_DB), sum(GLE15_CR) - sum(GLE15_DB)) &' '& if(Category = 'FIN',sum(GLE15_DB) > sum(GLE15_CR), sum(GLE15_DB) -sum(GLE15_CR))
Is there a way to do this, perhaps with master items and stuff?
Also how does the excel template system work for the P&L system, I can't find concrete examples or instructions.
Thanks a bunch!
DC
Hi Dries,
check this:
i hope that helps