Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to recreate a table that was previously used in Excel and I'm stuck...
Here's the straight table
My dimension "Activité" has several operations that are used in the making of each "Article"
The expression is the total time (in hundredths) used for each activity
Here is the Pivot table:
I'm unable to find how I could get a final column containing the SUM of the time for each Article like in my Excel file
I tried several ways (aggr function, ...) but I'm stuck
Any help is appreciated
Thanks !
FG
Hi,
you will need to add more details here, try to attach sample data or sample app to take a look
Hi,
I'd like to be able to show the total for each rows, as per this mock-up example
Dimension developed is "ACTIVITY" (in blue)
Expression is "TIME" (in red)
What I would like to achieve "TOTAL TIME" (adding all the time of each activities) (in green)
Thank you
Can you scramble the data if it is sensitive and attach a sample app?
I have to test it
Hi Fabien, if the expression is just Sum(TIME), checking the 'show partial sums option' for Activité dimension in presentation tab should work. Sometimes with vertical dimensions needs to save, close and open to refresh the chat and see the totals.
If the expression is more complicated the Aggr option will be like:
Sum(Aggr(CurrentExpression, Dim1, Dim2... DimN))
Here is a qvw file with some of the same data (Inline)
PFA
Is this what you need ?
yes thats it!
i feel stupid now. i was sure that i tried 'show partial sums' before!!!???
thank you a lot
yes, thanks
as I said on Marin's post, i was sure that i tried it before....
thanks again
no problem, you're welcome.
don't forget to close the thread