Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody, I have the following pivot table:
the value of the column TOTAL comes from the following formula;
SUM({< CONTABILIDAD.Categoria={"VENTAS"}>} CONTABILIDAD.Amount)
But what I need is something like this:
I want to repeat in every row the sum of the amount but only the Category="VENTAS" in order to acchive the % of every category in relation to the Category="VENTAS".
Thanks in advance
Try something like this:
SUM({< CONTABILIDAD.Categoria={'VENTAS'}>} TOTAL <YEAR, MONTH> CONTABILIDAD.Amount)
, assuming that YEAR and MONTH are your actual Field names (not just the dimension labels)...
Also, notice that I replaced your double quotes with single quotes - you only need to use double quotes for a search. For string values, use single quotes.
Check out my new book QlikView Your Business. In the book, I describe the use of TOTAL, AGGR, Set Analysis and many other advanced analytical techniques.
cheers,
Oleg Troyansky
Try something like this:
SUM({< CONTABILIDAD.Categoria={'VENTAS'}>} TOTAL <YEAR, MONTH> CONTABILIDAD.Amount)
, assuming that YEAR and MONTH are your actual Field names (not just the dimension labels)...
Also, notice that I replaced your double quotes with single quotes - you only need to use double quotes for a search. For string values, use single quotes.
Check out my new book QlikView Your Business. In the book, I describe the use of TOTAL, AGGR, Set Analysis and many other advanced analytical techniques.
cheers,
Oleg Troyansky
Yeah!! It works. Thank you.