Adding a new dimension to pivot table

[#1]

Hi,

Currently, I have the following data presented in listbox in qlikview as follows:

Where complexity is being defined as an expression such that: simple: timetaken<11, average: 11 <timetaken<20, complex >20

complexity	category	timetaken
simple	A	8
complex	B	30
average	C	17
simple	D	9
complex	E	25

May I know if there is anyway to put this into a pivot table such that the first dimension will be complexity, followed by category, and the expression will be timetaken?

I tried taking the same expression for complexity and copy into the calculated dimension in pivot table. but it shows calculation error.

P.S: Please do not attach qlikview files, I cant seem to download and view it on my qlikview.

Thanks

[#2]

It says calculation error when I were to do step 4.

my  original expression is

if((interval(if(turnaroundtime>=0,Round(Avg(turnaroundtime)))/86400,'d:hh:mm:ss'))<1,'Simple',
if((interval(if(turnaroundtime>=0,Round(Avg(turnaroundtime)))/86400,'d:hh:mm:ss'))>=1 and (interval(if(turnaroundtime>=0,Round(Avg(turnaroundtime)))/86400,'d:hh:mm:ss'))<3,'Moderate',
if((interval(if(turnaroundtime>=0,Round(Avg(turnaroundtime)))/86400,'d:hh:mm:ss'))>=3 and (interval(if(turnaroundtime>=0,Round(Avg(turnaroundtime)))/86400,'d:hh:mm:ss'))<10,'Advanced','Complex')))

It surfaced calculation error.