Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
asknyldz
Contributor III
Contributor III

Pivot Table Expressions

Hi there,

I want to add "Actual vs Budget" Expression in this pivot table. How can i do this?

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Use two expressions on a table/chart with MONTH as a dimension:

Sum({<TYPE = {ACTUAL}>} AMOUNT)

Sum({<TYPE = {BUDGET}>} AMOUNT)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

Or use the expression Sum(AMOUNT) with MONTH and TYPE as dimensions

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable

Hi,

Please find attached application for your info.