How to make a box with indicators?

[Anonymous]

Cycle button: Company Area Article	sum(Forecast)	sum(Sales)	Realized sum(Forecast) - sum(Sales)
Netherlands	150	100	- 50
England	100	200	+ 100
Italy	50	50	0

Forecast - Sales indicators

When you click on the pivot table selects all records of dimensions 'Company', 'Area' or 'Article' where the forecast is behind Sales.

Idem for icons and to see which records are on schedule.

How do I realize this box with indicators?

[miguelbraga]

Hey there,

Can you please share a (QVW) document and/or a Excel file with your results?

Thanks,

MB

[#3]

one option would be to build text boxes and when defining each text box, point to the imate you want - you can then go to the Action tab and make the appropriate selections as far as what you want to do when the user clidcks such as select in field and the field would be company

[Anonymous]

Here the Excel file with results.