****************************************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-X1GEN2
Path     : C:\Users\kgnazdowsky\Documents\Find IT EZ Docs\Test Cases\PowerBI\Store Sales.pbix
****************************************************************************************************

-------------------------------------------------- "Store Sales Overview" Visualization "8611c361d6d685e80665" Datasource Filter --------------------------------------------------

SELECT
	"FiscalMonth"
	,"This Year Sales"
	,"Total Sales Var %"
FROM
	"t"."Time"
	,"s"."Sales"
ORDER BY
	"FiscalMonth" ASC
	,"FiscalMonth" ASC


-------------------------------------------------- "Store Sales Overview" Visualization "b75483a790029dd4a1c6" "Categorical" Filter --------------------------------------------------

	"Store Type" = "'Same Store'"


-------------------------------------------------- "Store Sales Overview" Visualization "b75483a790029dd4a1c6" Datasource Filter --------------------------------------------------

SELECT
	"District"
	,"StoreNumber"
	,"Sales Per Sq Ft"
	,"This Year Sales"
	,"Total Sales Var %"
FROM
	"d"."District"
	,"s"."Store"
	,"s1"."Sales"
WHERE
	"Store Type" = "'Same Store'"


-------------------------------------------------- "Store Sales Overview" Visualization "8e0f98274cab22c6a80e" Datasource Filter --------------------------------------------------

SELECT
	"Chain"
	,"This Year Sales"
FROM
	"s"."Store"
	,"s1"."Sales"


-------------------------------------------------- "Store Sales Overview" Visualization "28e166680a992ae270ad" Datasource Filter --------------------------------------------------

SELECT
	"This Year Sales"
FROM
	"s"."Sales"


-------------------------------------------------- "Store Sales Overview" Visualization "820c6c0a465825cdbaa6" Datasource Filter --------------------------------------------------

SELECT
	"PostalCode"
	,"Store Type"
	,"This Year Sales"
FROM
	"s"."Store"
	,"s1"."Sales"
ORDER BY
	"This Year Sales" DESC


-------------------------------------------------- "Store Sales Overview" Visualization "ad292c567a76d115d6b0" Datasource Filter --------------------------------------------------

SELECT
	"Last Year Sales"
FROM
	"s1"."Sales"
ORDER BY
	"Last Year Sales" DESC


-------------------------------------------------- "Store Sales Overview" Visualization "80525a2a6cb0c6829860" Datasource Filter --------------------------------------------------

SELECT
	"New Stores"
FROM
	"s"."Store"
ORDER BY
	"New Stores" DESC


-------------------------------------------------- "District Monthly Sales" Visualization "1deec7668b4e00593c8a" Datasource Filter --------------------------------------------------

SELECT
	"Name"
	,"Chain"
	,"TotalSales"
FROM
	"s"."Store"
	,"s1"."Sales"
ORDER BY
	"TotalSales" DESC


-------------------------------------------------- "District Monthly Sales" Visualization "2c29e3187a640040ca08" Datasource Filter --------------------------------------------------

SELECT
	"FiscalMonth"
	,"Last Year Sales"
	,"This Year Sales"
	,"Total Sales Variance %"
FROM
	"t"."Time"
	,"s"."Sales"
ORDER BY
	"FiscalMonth" ASC


-------------------------------------------------- "District Monthly Sales" Visualization "591aa65a098c04b86a92" Datasource Filter --------------------------------------------------

SELECT
	"Category"
	,"Total Sales Variance %"
	,"Avg $/Unit TY"
	,"This Year Sales"
FROM
	"i"."Item"
	,"s"."Sales"


-------------------------------------------------- "New Stores" Visualization "VisualContainer1" Datasource Filter --------------------------------------------------

SELECT
	"FiscalMonth"
	,"Total Sales Variance %"
FROM
	"t"."Time"
	,"s"."Sales"
	,"s1"."Store"
WHERE
	"Store Type" = "'New Store'"


-------------------------------------------------- "New Stores" Visualization "80313843c4902b4d037e" Datasource Filter --------------------------------------------------

SELECT
	"FiscalMonth"
	,"Last Year Sales"
	,"This Year Sales"
FROM
	"t"."Time"
	,"s"."Sales"
	,"s1"."Store"
WHERE
	"Store Type" = "'New Store'"
ORDER BY
	"FiscalMonth" ASC


-------------------------------------------------- "New Stores" Visualization "7bcd06954e309e882c00" Datasource Filter --------------------------------------------------

SELECT
	"Chain"
	,"Name"
	,"Buyer"
	,"This Year Sales"
	,"Last Year Sales"
	,"Total Sales Var %"
	,"Total Sales Var"
FROM
	"s1"."Sales"
	,"s"."Store"
	,"i"."Item"
WHERE
	"Store Type" = "'New Store'"
ORDER BY
	"This Year Sales" DESC


-------------------------------------------------- "New Stores" Visualization "97ef12cb83896036aad7" Datasource Filter --------------------------------------------------

SELECT
	"Last Year Sales"
	,"This Year Sales"
FROM
	"s"."Sales"
	,"s1"."Store"
WHERE
	"Store Type" = "'New Store'"


-------------------------------------------------- "New Stores" Visualization "e2a11e48e84b4d7d7c3a" Datasource Filter --------------------------------------------------

SELECT
	"TotalSalesTY"
FROM
	"s"."Sales"
	,"s1"."Store"
WHERE
	"Store Type" = "'New Store'"


-------------------------------------------------- "Page 4" Visualization "832f7ef35dde77d0fcb6" Datasource Filter --------------------------------------------------

SELECT
	"TotalUnits"
	,"Name"
FROM
	"s"."Store"
	,"s1"."Sales"
ORDER BY
	"TotalUnits" DESC


-------------------------------------------------- "Info Page" Visualization "f5e94eca32c5e52ad068" Datasource Filter --------------------------------------------------

SELECT
	"Category"
	,"TotalSales"
FROM
	"i"."Item"
	,"s"."Sales"
ORDER BY
	"TotalSales" DESC