Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Des-H
Contributor
Contributor

Column Headers as Filter

Hi.  I have an excel data set where I have two columns called FYear (Fiscal Year) and CYear (Calendar Year).

Can I create a filter in QlikSense Cloud where I can choose whether to use Fiscal Year or Calendar Year to calculate sum of Amount?

SAMPLE DATA.jpg

 

Labels (2)
1 Reply
emrekaya
Contributor III
Contributor III

Do you want to show them in a table or you just want to sum them up? If you want to see the summation of the values based on filters in a KPI, you can use crosstable