Type of Date variable as dimension

[marqupcmb]

I have 3 differents dates:

PostingDate

InvoiceDate

GIMTDate

each one is a type of activity and is on a different table

What I want to do is have a Table Box where I can select one of those dates and in the same line graphic using as dimension the date selected and as the expression the sum of the amount related.

Somebody have any ideas? I'm sure it can be done with variables but I don't get how can it be done.

[Anonymous]

Do you want all the three dates and related sum in a single table box?

[MarcoWedel]

Hi,

maybe helpful:

Canonical Date

Radio buttons

regards

Marco

[marqupcmb]

I want to show in the same graphics the sums by the differents dates by selecting the type of date "action"

something like this

Is not working but is the idea... I can Select the type of date and it will change on the graphic dimension

My idea is put on the graphic dimension a variable that will take the date depending on the type of date selected

[muthukumar77 · Accepted solution]

Hi,

Refer this app,