Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, in a pivot table I have one field with values 1, 2 and 3.
I want to divide one amount field by SUM(amount) when field value = 1, for each value (1,2,3).
Description | Totals | % Sales |
---|---|---|
Sales | 1000 | 100% |
Cost | 500 | 50% |
Other Cost | 200 | 20% |
Thanks in advance
Sebastian
May be this
Sum(Value)/Sum(TOTAL {<Description = {'Sales'}>} Value)
Wonderful!
It's works!
Thank you
In a pivot table, "Totales" column is the total amount of Account. % Sobre Venta is Totales divided by Totales when Account = "Ingresos".
When two years are choosen, the % value is distributed across each year, example: in "Ingresos" line, % values are 16.84% and 83.16%, both sumarized values totals 100%.
I need that each value represent the % belongs its year. In this case, both column must be 100% (100% for 2017 and 100% for 2018).
The table looks like this:
I really appreciate your support.
Best regards,
Sebastián Martínez
Then try this
Sum(Value)/Sum(TOTAL <YearField> {<Description = {'Sales'}>} Value)
It works!!!
Thanks a lot!
May be approach it like this
Hi Sunny, in that link you included one file called "GSD_Value_Scorecard_v1.qvw" but is impossible to open it.
Could you explain in simple words how it works the function/formula?
Thanks,
Isn't work because the colum still appear in 2018.