Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart table with 1 dimension and multiple expressions.
In this dimension there are different lines (rows). Between these rows I want to add a calculated field. In the attached picture you see exactly what I want, but I really don't have a clue how to do this.
Does someone know how to do this??
Hi
This could be a little more complex than you thought. I suggest that you post your model (at least with sample data if its too big/confidential) so that someone can show your how.
Please also provide details of the desired calculated expression.
Regards
Jonathan
Hi,
Please find an example attached (with fake data). What I want is a row under 'Operating margin' which is a calculated field based on the following formula:
'Operating Margin' divided by 'Total Revenue'
Hi
Did you find a solution to your question ? I'm also interested by this.
Hi,
I have not received an answer on this yet. As far as I know this is not possible (unfortunately..).
Thank you for your answer. Since my last post, I do maybe have found a way to achieve that by creating a island table to create rows label, and after you create a conditional formula based on labels.
Hope this help.
it would be easier to add it in the actual reload :
data:
LOAD PL,
Department,
Amount
FROM
C:\Users\motter\Desktop\Example.xls
(biff, embedded labels, table is Sheet1$);
AdditionalData:
LOAD
'Operating Margin divided by Total Revenue' as PL,
min(Department) as Department,
sum(Amount) as Amount
Resident data
Where
(PL = 'Operating Margin' or PL = 'Total Revenue')
and Department = '1';
AdditionalData:
LOAD
'Operating Margin divided by Total Revenue' as PL,
min(Department) as Department,
sum(Amount) as Amount
Resident data
Where
(PL = 'Operating Margin' or PL = 'Total Revenue')
and Department = '2';
Hi,
Can you post an example with respect to island table and how we can create calculated rows in it!!!!
Thanks in advance!!!!
Hi,
Can you post an example with respect to island table and how we can create calculated rows in it!!!!
Thanks in advance!!!!